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,
I am trying to subtract a measure from another based on a data field value, the subtraction working for numbers but, not percentage values. Can someone tell me what's wrong with the below DAX.
Cur.Month | LastYearSameMonth | Diff |
98.93% | 98.59% | |
2.986215989 | 1.2795 | -1.70672 |
Hi @Rajsheisan ,
I do not know what do these measures [LastYearSameMonth] and [Cur.Month] look like, but can you try to use the function VALUE() to transform text to number.
IFERROR( FORMAT(CALCULATE(value([LastYearSameMonth])-value([Cur.Month])), "0.00%"), BLANK())
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks. I managed get it done.
Hi @Rajsheisan ,
I'm glad your problem is solved. If my answer was helpful to you, please mark my reply or if you have a better way, please share and mark it as a solution so more people can find the answer quickly.
Best Regards
Community Support Team _ chenwu zhu
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 |