How Are We Doing THIS Year Versus the Same Time LAST Year?
This is a pretty common question, and a pretty common need. But there’s no DAX function that just DOES this.
For instance, getting a“Year to Date” calculation for, say, Total Sales, is pretty straightforward:
[YTD Sales] = CALCULATE([Total Sales], DATESYTD(Calendar[Date]))
Back to the point of this post: it turns out that you can “nest” a DATESYTD inside of a DATEADD!
[Prev Yr YTD Sales] = CALCULATE([Total Sales], DATEADD(DATESYTD(Calendar[Date]),-1,Year))
We have two requirement:
- You must have a well-constructed Calendar/Dates table
- You need to then USE that Calendar/Dates table on your pivot table
if you want more info click this link