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.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |