Forum Discussion
SirJJAnderson
Helper III
Helper IIIHow to Calculate MoM Percentage Change?
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 ch...
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 , Try like
chnage % = DIVIDE((SUM(Table1[Deliveries]) - [Deliveries MOM]), [Deliveries MOM])
And Mark it as % column
amitchandak
Super User
Super UserDelivery MOM is a measure no need of table name just [Delivery MOM] fine
No need of SUM too