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
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: A. CALCULATE ( [Total Sales], DATEADD ( Date[Date], -1, QUARTER ) ) * Explanation: - DATEADD( Date[Date], -1, QUARTER ) shifts the current filter context back by one quarter. - Wrapping it in CALCULATE applies that shifted context to the [Total Sales] measure, giving you the sales from the previous quarter relative to the selected period. * Why not the others: - B. DATESQTD(Date[Date]) → Returns dates from the start of the quarter to the current date, not the previous quarter. - C. TOTALQTD([Total Sales], Date[Date]) → Returns the quarter-to-date total for the current quarter, not the previous one. - D. PARALLELPERIOD(Date[Date], 1, QUARTER) → Shifts forward one quarter, not backward. To get the previous quarter, you’d need -1.
For C: CALCULATE([Total Sales], PARALLELPERIOD(Date[Date], 1, QUARTER)) brings you one quarter ahead. If C was CALCULATE([Total Sales], PARALLELPERIOD(Date[Date], -1, QUARTER)) then it would have been correct too
A. CALCULATE ( [Total Sales], DATEADD (Date[Date], -1, QUARTER ) ) Explanation: DATEADD(Date[Date], -1, QUARTER) shifts the filter context exactly one quarter back. CALCULATE applies this filter context to Total Sales to get the sales from the previous quarter. Why not the others? B. DATESQTD returns dates in the current quarter-to-date, not previous quarter. C. TOTALQTD calculates quarter-to-date totals for the current quarter, not previous quarter. D. PARALLELPERIOD(Date[Date], 1, QUARTER) shifts forward one quarter (+1), not backward.