Show Positive and Negative for %

[Anonymous]

Hello,

I am trying to convert excel report into power bi.

I am trying to show Power BI % column SAME as Excel % column.I have used SIGN function  and FORMAT function but not getting correct result.Total row should show negative sign as well.

	Power BI %	Excel %
A	-2.80%	-2.8%
B	1.60%	1.6%
C	-0.10%	-0.1%
D	-1.30%	-1.3%
E	5.40%	5.4%
F	-2.30%	-2.3%
Total	0.07%	-1.3%

***To get Power BI% =pqr/mnp

-pqr and mnp both have decimal number

[MFelix · Accepted solution]

Hi @Anonymous,

Be aware that the calculations in PBI don't work in the same way as in Excel, you need to create a calculated measure and not a column rewrite your formula to a measure with the following code:

% Calculation =SUM(Table[pqr]) / SUM(Table[mnp])

Then format as %.

Regards,

MFelix

[Anonymous]

Hi MFelix,

Thank you so much for your suggestion.It is working perfectly fine and thank yo so much for your tips.