Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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....
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

     

     

    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

MFelix's avatar
MFelix
Super User
7 years ago

 

 

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's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi MFelix,

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