cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
WorkingChepe Frequent Visitor
Frequent Visitor

IF for 2 or more conditionals

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

1 ACCEPTED SOLUTION

Accepted Solutions
WorkingChepe Frequent Visitor
Frequent Visitor

Re: IF for 2 or more conditionals

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

3 REPLIES 3
Super User
Super User

Re: IF for 2 or more conditionals

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

 

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

   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


WorkingChepe Frequent Visitor
Frequent Visitor

Re: IF for 2 or more conditionals

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?

WorkingChepe Frequent Visitor
Frequent Visitor

Re: IF for 2 or more conditionals

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