Expression that yields variant data type with IF statement?

Question

I used an if statement for&nbsp;a calculated column&nbsp;with no problem if my TRUE variable was fixedexample:&nbsp;IsInventry = if(LComment[FileNo]=7,"True",""&nbsp;If I use a variable as the TRUE&nbsp;example: IsInventry = if(LComment[FileNo]=7,LComment[RecordNo],""I get the error&nbsp;Expression that yields variant data typeIs there any way around this?&nbsp;&nbsp;

v-jiascu-msft · Accepted Answer

Hi&nbsp;unclejemima,&nbsp;Please try to replace the "" with BLANK().&nbsp;&nbsp;Best Regards,Dale

Forum Discussion

Expression that yields variant data type with IF statement?

2 Replies

Related content

DAX expression ignoring blanks statement when extra filter is added

DAX - Variant Data Type error IF statement

Switch statement - Multiple expressions

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

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