Forum Discussion
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 ...
sneevand not sure why you will do that, you just need to create 3 measure and you should use date dimension and then use previousyear dax function to get value for the previous year, which means whatever year you are looking at, you will get previous year value.
There are tons of posts on time intelligence and previous year calculations.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡