Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
CALCULATE SUM DATESBETWEEN it could be misleading the "startyear" and "endate" labels as there is no explicit mention this VARS (calculated above in the DAX expression) are retuning PREVIOUS YEAR startdate and enddate. Also, as mentioned by several others, the SAMEPERIODLASTYEAR function requires one single argument ([Date])
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Calculate Sum DatesBetween DATESBETWEEN required 3 argument
The last one is datesbetween: from MS documentation DATESBETWEEN(<Dates>, <StartDate>, <EndDate>). SAMEPERIODLASTYEAR(<dates>) takes only 1 mandatory argument
CALCULATE SUM DATESBETWEEN it could be misleading the "startyear" and "endate" labels as there is no explicit mention this VARS (calculated above in the DAX expression) are retuning PREVIOUS YEAR startdate and enddate. Also, as mentioned by several others, the SAMEPERIODLASTYEAR function requires one single argument ([Date])