Forum Discussion

smithshire's avatar
smithshire
Frequent Visitor
3 years ago
Solved

Previous 2 years

I currently have a visual that calculates the YTD and the I use the PREVIOUSYEAR function to calculate the full previous year. Is it possible to calculate the year previous to the previous year i.e. ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago
    = CALCULATE([Overall],DATEADD(CalendarTable[Dates],-2,YEAR))
Ahmedx's avatar
Ahmedx
Super User
3 years ago
= CALCULATE([Overall],DATEADD(CalendarTable[Dates],-2,YEAR))