Forum Discussion
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 change between the two columns.
See columns Deliveries & Deliveries MoM, and Delivery % Change error up top in my calculation
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
4 Replies
- amitchandak
Super User
Delivery MOM is a measure no need of table name just [Delivery MOM] fine
No need of SUM too
- mahoneypat
Microsoft Employee
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
SirJJAndersonSo 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
SirJJAnderson , Try like
chnage % = DIVIDE((SUM(Table1[Deliveries]) - [Deliveries MOM]), [Deliveries MOM])
And Mark it as % column