Forum Discussion
Show Positive and Negative for %
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
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
2 Replies
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