March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi MFelix,
Thank you so much for your suggestion.It is working perfectly fine and thank yo so much for your tips.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
88 | |
78 | |
65 | |
59 |
User | Count |
---|---|
140 | |
122 | |
105 | |
94 | |
90 |