Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Column that returns prior year value

Hi All,    I am trying to add a column in to my table model that returns Prior Year amounts. Please see attached. For some reason my current formula is not working. Does anyone know how to solve fo...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

This one should be created as measure.

I use following

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date])))

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year)))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year))))
last year measure =CALCULATE(SUM(Sales[Sales Amount]),(dateadd('Date'[Date],-1,Year)))