Power BI Data Analyst (PL-300) · Free practice question 6 of 12
Previous month with DATEADD
A matrix shows monthly revenue at Skerry Telecom. The finance team wants a column that shows the previous month's revenue next to each month. Which measure is correct, assuming a marked Date table?
- A.CALCULATE([Revenue], DATEADD('Date'[Date], 1, MONTH))
- B.CALCULATE([Revenue], STARTOFMONTH('Date'[Date]))
- C.CALCULATE([Revenue], DATESMTD('Date'[Date]))
- D.CALCULATE([Revenue], DATEADD('Date'[Date], -1, MONTH))
Show answer and explanation
Correct answer: D. CALCULATE([Revenue], DATEADD('Date'[Date], -1, MONTH))
Why: DATEADD with -1 and MONTH shifts the dates in the current context back by one month, returning the prior month's revenue for each row. A positive interval returns the next month. DATESMTD gives month-to-date dates of the current month, and STARTOFMONTH returns only the first date of the current month.