Using IF with two different ResultIfFalse responses

[Anonymous]

Hey there. Newbie here. I have a column named Stock that contains a variety of values. I've created a new column that I would like to return a No or Yes value based on the below. 

What am I doing wrong? 🙂 

Stock Y/N = IF('Table'[Stock] = "No", "No", "Yes" OR "Some" OR "Not Many")

Stated differently, I'd like a "Yes" return on any value that is not "No" and not empty.

[V-lianl-msft]

Hi @Anonymous ,

Is this problem sloved?
If not, please let me know.

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

[mwegener]

Hi @Anonymous ,

check this out.

https://docs.microsoft.com/en-us/dax/switch-function-dax

Stock Y/N = 
SWITCH(
      'Table'[Stock],
	  BLANK(), BLANK(),
	  "No"   , "No"   ,
	  "Yes"
      )

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Try creating calculated columns like this:

Stock Y/N = IF('Table (2)'[Stock]<>"No"&&NOT(ISBLANK('Table (2)'[Stock])),"Yes","No")

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

[amitchandak]

@Anonymous , In a new column this should have worked

Stock Y/N = IF('Table'[Stock] = "No", "No", "Yes")

Means when value is no then return No else return yes

Or

Stock Y/N = IF('Table'[Stock] in{ "Yes" , "Some" , "Not Many"} , "Yes","NO")

Or

Stock Y/N = IF('Table'[Stock] = "Yes" || 'Table'[Stock] = "Some" || 'Table'[Stock] = "Not Many"} , "Yes","NO")

For And you can use &&