Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
109 | |
100 | |
39 | |
31 |
User | Count |
---|---|
154 | |
122 | |
77 | |
74 | |
44 |