Month on Month Evolution Measure

[Anonymous]

Hello Guys,

I need your help

I'm trying to input a MoM share growth measure on a PBI Matrix, but I can't . Can you help?

Example:

Month 1: 5% share

Month 2: 10 % share

Desired output:
Example:
So in Month 2 in the column MoM Cat 1 should be: (Past - Present) / (Present) or ( 0.05 - 0.10) / 0.10 = 50% growth

Sample File:

Sample 

Thanks a lot

[Anonymous · Accepted solution]

Hi @Anonymous ,

Sorry for that I could access your sample file. You could refer to this blog to learn  How to provide sample data in the Power BI Forum

But I have built a data sample to test:

1. Assume MS% is the column not a measure

2. Add a Date column for calulation later

Date = DATE(LEFT([Year/Month],4),RIGHT([Year/Month],2),1)

Then according to my understanding, your expected output may like this:

If so, please try:

MoM Cat 1 = 
var _pre=CALCULATE(SUM('Table'[MS%]),PREVIOUSMONTH('Table'[Date]),ALLEXCEPT('Table','Table'[Brand],'Table'[Bi Cat 1]))
return DIVIDE( _pre-SUM('Table'[MS%]), SUM('Table'[MS%]))

Output:

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