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 SAMEPERIODLASTYEAR 'DATE'[DATE] To calculate total sales from the equivalent month of the previous year, you typically use the DAX function SAMEPERIODLASTYEAR or PARALLELPERIOD depending on your model. However, the options for PARALLELPERIOD are not available as a choice in this diagram, so only SAMEPERIODLASTYEAR is the right fit. Total Sales Previous Year = CALCULATE( [Total Sales], SAMEPERIODLASTYEAR('Date'[Date]) ) --- This one is not an option (last box does not have three arguments as option) Total Sales Previous Year = CALCULATE( [Total Sales], PARALLELPERIOD('Date'[Date], -12, MONTH) )
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: - Outer function: CALCULATE - Time shift: SAMEPERIODLASTYEAR - Date column: 'Date'[Date] (from the related Date table, not the fact table)
Total Sales Previous Year = CALCULATE( [Total Sales], SAMEPERIODLASTYEAR('Date'[Date]) )
CALCULATE SAMEPERIODLASTYEAR 'DATE'[DATE] To calculate total sales from the equivalent month of the previous year, you typically use the DAX function SAMEPERIODLASTYEAR or PARALLELPERIOD depending on your model. However, the options for PARALLELPERIOD are not available as a choice in this diagram, so only SAMEPERIODLASTYEAR is the right fit. Total Sales Previous Year = CALCULATE( [Total Sales], SAMEPERIODLASTYEAR('Date'[Date]) ) --- This one is not an option (last box does not have three arguments as option) Total Sales Previous Year = CALCULATE( [Total Sales], PARALLELPERIOD('Date'[Date], -12, MONTH) )