Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
4 years ago
Solved

Calculated Column

Hi all,   I need to create calculated column in power bi as below: Column =(col1-col2)/col2   Will appreciate your help. 
Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi sdhn 

     

    try this:

     

    Column =
IF (
    [col2] = 0,
    BLANK (),
    IF ( [col1] - [col2] < 0, 0, ( [col1] - [col2] ) / [col2] )
)

     

    If my posts helps, please consider accepting them as solutions to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

sdhn's avatar
sdhn
Responsive Resident
4 years ago

Great , thi ssolve the issue.  One more request.

I am getting negative figures in few rows. 

as -0.3 %.  I want to display any "-" as '0'.   Can you help on this too? thanks 

 

sdhn's avatar
sdhn
Responsive Resident
4 years ago

I meant Just display 0 if there is any negative "-"  number 

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    Hi sdhn 

     

    try this:

     

    Column =
IF (
    [col2] = 0,
    BLANK (),
    IF ( [col1] - [col2] < 0, 0, ( [col1] - [col2] ) / [col2] )
)

     

    If my posts helps, please consider accepting them as solutions to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/