cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted

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

View solution in original post

3 REPLIES 3
Highlighted
Community Champion
Community Champion

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

 

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

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?

Highlighted

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors