Forum Discussion
Dynamic PY,CY,NY
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) valu...
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.