How to Calculate MoM Percentage Change?

[SirJJAnderson]

I tried following a solution I found online and it isn't quite working. I was able to create a column that shows the prior month's data, but I can't figure out how to then calculate the percentage change between the two columns.

See columns Deliveries & Deliveries MoM, and Delivery % Change error up top in my calculation

[mahoneypat · Accepted solution]

You can try this approach.

Pct Change MOM = var thismonth = sum('Table1'[Deliveries])

var lastmonth = [Deliveries MOM] //your existing measure

return divide((thismonth-lastmonth), lastmonth)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[mahoneypat · Accepted solution]

You can try this approach.

Pct Change MOM = var thismonth = sum('Table1'[Deliveries])

var lastmonth = [Deliveries MOM] //your existing measure

return divide((thismonth-lastmonth), lastmonth)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[SirJJAnderson]

So this formula worked, but technically is not correct. You're right about needing to subtract Deliveries MOM from Table1[Deliveries] before I do the divide.

Delivery % Change = DIVIDE(SUM(Table1[Deliveries]), [Deliveries MOM])

How would I adjust this formula to do that? Something like the below? The below doesn't throw an error but the result is wrong.

Delivery % Change = DIVIDE((SUM(Table1[Deliveries]) + [Deliveries MOM]), [Deliveries MOM])

[amitchandak · Accepted solution]

@SirJJAnderson , Try like

chnage % = DIVIDE((SUM(Table1[Deliveries]) - [Deliveries MOM]), [Deliveries MOM])

And Mark it as % column

[amitchandak]

@SirJJAnderson 

Delivery MOM is a measure no need of table name just  [Delivery MOM] fine

No need of SUM too