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.
Hi,
Im trying to calculate a MoM change from this variable:
@Anonymous ,
Mesuare minus measure sometimes doesn't work. Could you share some sample data and clarify the expected result?
Regards,
Jimmy Tao
Hi,
This is the data:
Year | Month | amount | total amount | percentage |
2018 | August | $12,223,940,162.80 | $256,682,471,312.66 | 4.76% |
2018 | September | $12,398,403,638.51 | $249,201,281,497.68 | 4.98% |
2018 | October | $13,335,632,187.75 | $254,938,640,117.02 | 5.23% |
2018 | November | $13,257,593,286.08 | $271,370,276,657.27 | 4.89% |
2018 | December | $13,526,113,348.24 | $272,994,377,931.33 | 4.95% |
2019 | January | $13,973,302,229.23 | $268,551,517,278.73 | 5.20% |
2019 | February | $15,389,685,991.45 | $288,150,974,563.63 | 5.34% |
2019 | March | $15,780,812,442.37 | $292,420,018,287.96 | 5.40% |
2019 | April | $16,118,617,756.52 | $289,750,213,615.55 | 5.56% |
2019 | May | $16,283,954,632.74 | $288,871,277,307.34 | 5.64% |
2019 | June | $16,892,080,720.50 | $296,401,707,114.24 | 5.70% |
2019 | July | $16,575,910,084.15 | $290,215,200,574.59 | 5.71% |
I would like to obtain the MoM change of the percentage.
I use measures because creating columns for this calculation, with the exact same formula, returned extremely different results since it was agreggating per client; therefore, i cannot use column calculations but measure ones.
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 | |
101 | |
86 | |
64 |