Forum Discussion

Adhavan's avatar
Adhavan
Frequent Visitor
4 years ago

Calculate Average Monthly Growth Rate with Negative Value

Hi All,

 

I have data set of Monthly Revenue for two years. I am trying to calculate the average Growth rate for the year.

 

I achieved the monthly growth rate by 

 

= ( Total Revenue - Previous Month Revenue ) / Total Revenue

 

But, I couldn't find any option to calculate Average Growth Rate for the year.

 

Here I have attached the Dataset for your reference. Your support is more appreciated. 

 

The Value 7.3% is wrong. The actual result is 5.20%

 

Thanks in Advance,

Manikandan

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Adhavan ,

     

    If you want the Total of the [MoM Growth] is the averge value, you could create a measure like.

    Total is average = IF(HASONEVALUE('Table'[Year]),[MoM Growth],AVERAGEX('Table',[MoM Growth]))

     

    You see, 3.28% is the average of [MoM Growth].

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Adhavan's avatar
      Adhavan
      Frequent Visitor
      4 years ago

      Hi Stephen,

       

      Really thabks for your response. 😉.

       

      I have treied the same AverageX function with my dataset. My I got some different result.

      The AvergeX Function didn't generate any result and it showing blank value.

       

      Since I am new to PBI, struggle to understand your points I beleive. Can you my dataset and correct my mistakes, if possible.

      Herewith I have attached my PBI file.

      https://app.box.com/s/jhbsj6nclrqj5cu48mgwdvcb4718b0q4

       

      Thanks,

      Adhav

  • onurbmiguel_'s avatar
    onurbmiguel_
    Icon for Power Participant rankPower Participant
    4 years ago

    Hi 

     

    My suggestion is that you use the Matrix visual: 

    and maybe you need to adjust your DAX measure for the previous month, i share with you this example: 

     

    Previous month Amount = 
CALCULATE(
    Purchases[Purchase Amount],
    PREVIOUSMONTH('Calendar'[Date])
)

     

    try and let me know how it work. 

     

    Best regards

    Bruno Costa | Responsive Resident

     

    Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

    Take a look at the blog: PBI Portugal 

     

    • Adhavan's avatar
      Adhavan
      Frequent Visitor
      4 years ago

      Hi Bruno,

       

      Thanks for your reposnse.  

       

      I have tried your suggestion, but, still get the expected result. Moreever, I am willing to showcase the result as line Chart and CARD.

       

      Just for verification purpose, I created as tabl.

       

      Thanks,

      Mani