Forum Discussion

Adhavan's avatar
Adhavan
Frequent Visitor
3 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 - Previou...
Need Help
onurbmiguel_'s avatar
onurbmiguel_
Icon for Power Participant rankPower Participant
3 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
3 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