Forum Discussion

vivek_rana's avatar
vivek_rana
Frequent Visitor
4 years ago
Solved

Average Growth Rate

How to calculate Average growth rate over time Dax query   Let say Number of milk cans sold by the company in the past four years: 2018 = 350 2019 = 450 2020 = 500 2021 = 650 Calculate ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    The answer should be -7.18%.  You may download the PBI file from here.

    Hope this helps.

vivek_rana's avatar
vivek_rana
Frequent Visitor
4 years ago

Thank you Ashish . That worked.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

You are welcome.