Forum Discussion
Year over Year calculation
I am trying to achieve a YoY calc with values from same table.
I currently have a table as a visual where you can see the the years in columns with respective info.
I have tried PARALLELPERIOD (year -1) and SAMEPERIODLASTYEAR, but data does not show properly, sometimes shows blanks.
The goal is to have it work dynamically when you switch years and Fiscal Months. The Time filters would determine the date range and I would need -1 date info for that time period.
Has anyone solved this before?
2 Replies
Take a look at DATEADD function.
https://docs.microsoft.com/en-us/dax/dateadd-function-dax
DateLastYear = DATEADD(DateTime[DateKey],-1,year)
