Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Switch is the code you are looking for. It allows you to do CASE statements.
Opening = SWITCH( [1AppropriateOpening], "YES", 1, "NO", 0, "N/A" )
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
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?
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |