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!

     

dreaves1's avatar
dreaves1
Helper II
6 years ago

It won't recognize my table now and I get an error message. 

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi dreaves1 ,

 

Or create a conditional column in 'Power Query'.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.