Forum Discussion
sneevand
5 years agoFrequent Visitor
YOY qty Measure, Dynamic
Hi Guys, We have below data yr qty salamt 2021 100 20000 2020 2 200 2019 3 99 We would like to get AVG price yoy 2021 =20000/100= 200 2020 =200/2= 100 2019 =99/3= 33 ...
V-lianl-msft
5 years agoCommunity Support
Hi sneevand ,
Please refer to these thread:
https://community.powerbi.com/t5/Desktop/YoY-Calculations/m-p/342299
https://community.powerbi.com/t5/Desktop/YoY-Qty-Measure/m-p/1604993
Then use the year slicer to dynamically display the comparison with the previous year.
If the problem persists,could you share the sample pbix via cloud service like onedrive for business?
Please remove any sensitive data before uploading.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.