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.

Gayani0000's avatar
Gayani0000
Regular Visitor
3 years ago

Hi, I have a request to calculate the average growth rate for the last 5 years, the last 7 years, and so on. I have calculated the average growth for all years but am struggling to do this new request in the Dax query.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share some data, explain the question and show the expected result.