Forum Discussion

dreaves1's avatar
dreaves1
Helper II
6 years ago
Solved

Create a custom column using an IF statement

Hi All,   I'm trying to create a custom column for offers rejected/rescinded out of two columns, Offers and Hires. I want to substract the number of Offers by Hires if the number of Offers is m...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi dreaves1 ,

     

     

    Create a new Column

     

    New Column =
SWITCH (
    TRUE (),
    'Table'[Offers] > 'Table'[Hires], 'Table'[Offers] - 'Table'[Hires],
    'Table'[Offers] < 'Table'[Hires], 'Table'[Offers],
    BLANK ()
)

     


    Regards,

    Harsh Nathani


    Appreciate with a Kudos!! (Click the Thumbs Up Button)

    Did I answer your question? Mark my post as a solution!

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi dreaves1 ,

 

 

Create a new Column

 

New Column =
SWITCH (
    TRUE (),
    'Table'[Offers] > 'Table'[Hires], 'Table'[Offers] - 'Table'[Hires],
    'Table'[Offers] < 'Table'[Hires], 'Table'[Offers],
    BLANK ()
)

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI dreaves1 ,

 

You need to create this in Power BI Desktop.

 

 

 

Regards,

Harsh Nathani