Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@SirJJAnderson , Try like
chnage % = DIVIDE((SUM(Table1[Deliveries]) - [Deliveries MOM]), [Deliveries MOM])
And Mark it as % column
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.
@SirJJAnderson , Try like
chnage % = DIVIDE((SUM(Table1[Deliveries]) - [Deliveries MOM]), [Deliveries MOM])
And Mark it as % column
Delivery MOM is a measure no need of table name just [Delivery MOM] fine
No need of SUM too
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |