Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm trying to create a table that gives me the MoM percentage change after each month. I'm close but getting strange results on in my table.
I've created a measure for the current months value, previous month's value, the difference. See results below. (note - these values are already percentages before going into this table)
For example, shouldn't 2022 May be showing -19.21% under DIFF, not -0.33%?
Solved! Go to Solution.
Hi,
You should create a Calendar Table with calculated column formulas fror Year, Month name and Month number. Sort the Month name by the Month number. Create a relationship from the __- date to the Date column of the Calendar Table. To your visuals, drag Year and Month name from the Calendar Table. Write these measures
Last MTD Efficiency = CALCULATE( [Waste Diverted Percentage - spoil],previousmonth(Calendar[Date]))
diff = [Waste diverted percentage - spoil] - [Last MTD Efficiency]
Hope this helps.
Hi,
You should create a Calendar Table with calculated column formulas fror Year, Month name and Month number. Sort the Month name by the Month number. Create a relationship from the __- date to the Date column of the Calendar Table. To your visuals, drag Year and Month name from the Calendar Table. Write these measures
Last MTD Efficiency = CALCULATE( [Waste Diverted Percentage - spoil],previousmonth(Calendar[Date]))
diff = [Waste diverted percentage - spoil] - [Last MTD Efficiency]
Hope this helps.
Hi
@Bullet_Train95 are you able to share the measure for "Waste Diverted Percentage - Spoil"
BR
User | Count |
---|---|
95 | |
89 | |
70 | |
63 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |