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

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/