Dynamic PY,CY,NY

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

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

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.