Dynamic PY,CY,NY

[AlanP514]

Hai Dax pro people's need your help 

I have a table called tracking file it is having projects amounts datarequirement is 

If user 2021 from year slicer they want to 

PY(2020) value ,CY(2021) value,NY(2022) Value 

Please help to achive this

[V-lianl-msft]

Hi @AlanP514 ,

You can refer to this blog. Create PY and NY measures according to the formulas involved:

https://blog.enterprisedna.co/financial-year-dynamic-filtering-in-power-bi-reports/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[serpiva64]

Hi,

it is not clear :

next year is a partial, you want to compare it with complete previous year or with the same partial (ex. till 11/04)?

[AlanP514]

With the same partial

[AlanP514]

I have a table called tracking file it is having projects amounts datarequirement is 

If user select 2021 from year slicer they want to see

PY(2020) value ,CY(2021) value,NY(2022) Value 

Please help to achive this