IF for 2 or more conditionals

[Anonymous]

Hi,

I'm new on Power Bi and looking to move an excel report to this tool, in this case I'm trying to use an IF formula but getting the following error:

Expressions that yield variant data-type cannot be used to define calculated columns.

The formula I'm trying to use for a Quality Asurance form:

1.Opening= IF([1AppropriateOpening]="YES",1,IF([1AppropriateOpening]="NO",0,"N/A"))

The answers you can get in this (and all other evaluated attributes are)

YES

NO

NA-Example 1

NA-Example 2

NA-Example n

[Anonymous]

Switch is the code you are looking for. It allows you to do CASE statements.

Opening = SWITCH(
	[1AppropriateOpening],
	"YES", 1,
	"NO", 0,
	"N/A"
)

[Anonymous · Accepted solution]

Hey Ross

I think I figured it out, 

Opening = SWITCH(
	[1AppropriateOpening],
	"YES", 1,
	"NO", 0,
	BLANK()
)

I think the error was for combining numbers and letters, my guess only, cuz with BLANK it worked

[Anonymous]

I still received the message:

Expressions that yield variant data-type cannot be used to define calculated columns

I'm getting the data from a Drop Down Column directly from SharePoint, do you think this has something to do with it?