Forum Discussion

juhoneyighot's avatar
juhoneyighot
Icon for Helper III rankHelper III
2 years ago

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

Hi! I'm new to PowerBI. I'm using the IF statement, unfortunately I'm getting this error "Expressions that yield variant data-type cannot be used to define calculated columns." Calculated Column: I...
Tips and Tricks
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

All it means is that all data returned in the IF statement should be of the same type.  It looks like this one is returning text or numbers