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. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

For a custom Column Formula in Power Query you can use

 

If [Offers] > [Hires] then [Offers] - [Hires] else [Offers]

 

Regards,

HN

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi dreaves1 ,

     

     

    Follow these steps

     

     

     


    Regards,

    Harsh Nathani


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

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