Forum Discussion
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 more than the number of Hires. If the number of Offers is least than the number of Hires, I want to keep the number in the Offers field. Can someone please demonstrate how this can be accomplished?
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!
8 Replies
dreaves1 - Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.That being said, the syntax for IF statements is:
DAX: IF([Column1] = "Something" || [Column 2] = "Something else",true,false)
You can use && and || for logical AND and OR statements.
Power Query: if [Column1] = "Something" then "True" else "False"
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!
