Subtract percentage value from percentage value

[Rajsheisan]

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.

if(Type= "percentage",

IFERROR( FORMAT(CALCULATE([LastYearSameMonth]-[Cur.Month]), "0.00%"), BLANK()),

IFERROR(CALCULATE([LastYearSameMonth]-[Cur.Month]), BLANK()))

below is the data sample

Cur.Month	LastYearSameMonth	Diff
98.93%	98.59%
2.986215989	1.2795	-1.70672

Thanks.

[v-chenwuz-msft]

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.

[Rajsheisan]

Thanks. I managed get it done.

[v-chenwuz-msft]

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