Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 c...
  • Anonymous's avatar
    Anonymous
    9 years ago

    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's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    Anonymous
    Not applicable
    9 years ago

    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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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