Forum Discussion
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...
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!
