Hello,

I may be in the wrong forum so please advise if I am.

I have created a DAX formula for comparing 3 different columns. Two of the columns are text value and the third is a number value. My formula looks like this: =IF([MAKE_BUY_STATUS]="Buy" &&[INVENTORY_ITEM_STATUS]="Active" &&[FIXED_LOT_MULTIPLIER]="", "Y", "N")

The purpose is to find any active buy item where the fixed lot multiplier has a null value and return yes if true otherwise return no

The fixed lot multiplier column is a number value and when I submit this formula I get the error that DAX does not support comparing values of type number with values of type text. Any help is much appreciated.

In Power Pivot management window, check the data type of the column [FIXED_LOT_MULTIPLIER]: it is probably of type number. This would explain why the comparison [FIXED_LOT_MULTIPLIER]="" creates an error whith the description you mention.
You could try  ISBLANK([FIXED_LOT_MULTIPLIER]) instead.

• Marked as answer by areno379 14 hours 24 minutes ago

The ISBLANK worked just fine. Thank you!