Forum Discussion
DAX Help
Team,
I need to calculate Previous year measures while selecting current year = Y. With below dax i am able to do when i select each year but when i select curr year = y measure breaks.
Here is Time table structure.
DAX Used :
Calculate(SUM('CIR'[YTDSales]),FILTER(ALL('Time'[Year]),'Time'[Year] = MAX('Time'[Year])-1))
1 Reply
- Please, before you try to do anything with time-intelligence, read the article(s) on www.sqlbi.com. You can start with this one: https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/
