DAX Help

[pmadam]

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))

[Anonymous]

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/