Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
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
Best regards
Bruno Costa | Super User
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
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
User | Count |
---|---|
90 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |