Forum Discussion
I have A column and has a list of value Also B column with list of value . i want to see the difference of A and B column For example: A as 18.89% AND B as 12.48% i want to see the value ...
Hi Prabhu,
Please check the below DAX measure to get expected result.
Different % =
Var check1 = ('Table'[a]-'Table'[b])
Var Positiveresult = "+ "&CONVERT(check1 *100,STRING) &"%"
Var Negativeresult = "- "&CONVERT(check1 *100,STRING) &"%"
Var Finalresult = IF(check1>0,Positiveresult,Negativeresult)
Return Finalresult
Appreciate a Kudos!
If this helps and resolves the issue, please mark it as a Solution!
Regards,
N V Durga Prasad