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!

 

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!

  • 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.