Forum Discussion
juhoneyighot
Helper III
Helper IIIExpressions that yield variant data-type cannot be used to define calculated columns.
Hello!
I'doing this IFERROR DAX formula:
Phase _ = IFERROR(IF('stx__legacy_fsjob'[# of _]="","", FIND("~", SUBSTITUTE('stx__legacy_fsjob'[_JobType_txt],"_","~",'stx__legacy_fsjob'[# of _]-1))),'stx__legacy_fsjob'[_JobType_txt])
However, this error occurs: Expressions that yield variant data-type cannot be used to define calculated columns.
Thank you for the help.
1 Reply
- audreygerred
Super User
This means you have a data type mismatch and are trying to use text and integer together for a calculation, but that isn't allowed.
