Forum Discussion
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 - Previou...
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.
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