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

[juhoneyighot]

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: IF('stx__legacy_fsjob'[NC.IN]="","",(LEN('stx__legacy_fsjob'[_JobType_txt])-(LEN(SUBSTITUTE('stx__legacy_fsjob'[_JobType_txt],"_","")))))

Can anyone help me on this.

Thank you.

[SamInogic]

Hi @juhoneyighot 

You can try below DAX expression,

IF('stx__legacy_fsjob'[NC.IN]="","",CONVERT((LEN('stx__legacy_fsjob'[_JobType_txt])-(LEN(SUBSTITUTE('stx__legacy_fsjob'[_JobType_txt],"_","")))),STRING))


The issue was your expression have true part as blank string value and false part returning length which is numeric data type so we need to have both values of same type.

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[juhoneyighot · Accepted solution]

It works. Thank you.