Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Displaying % as Ratio

Hi All,    I am trying to make a % visible in a different format.  E.g. Instead of 1.81% I want to show 1:50.   In Excel I use the following formula: "="1" & ":" & ROUND(($B$1/C1),0)" In Power ...
Need Help
Tips and Tricks
Tutorial Requests
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi Anonymous

     

    No worries, please see below the proposed solution.


    Here is the measure that I created

    Column E Result = "1:" & ROUND(CALCULATE(SUM('Table1'[A])/SUM('Table1'[B])),0)

    And this is what the result looks like

     

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi Anonymous

 

No worries, please see below the proposed solution.


Here is the measure that I created

Column E Result = "1:" & ROUND(CALCULATE(SUM('Table1'[A])/SUM('Table1'[B])),0)

And this is what the result looks like

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

very useful,thanks