Calculate Average Monthly Growth Rate with Negative Value

[Adhavan]

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

[v-stephen-msft]

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]

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_]

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]

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