DAX Error

[Anonymous]

Hi All,

I am getting the DAX error "Expressions that yield variant data-type cannot be used to define calculated columns."

The formula I have used is given below:

Safety Stock and Safety Time Alignment = IF('Master Data Hygiene (2)'[Buffer Profile]="NB","",IF(OR(1*'Master Data Hygiene (2)'[Safety Stock]>1*'Master Data Hygiene (2)'[Red Zone Quantity],1*'Master Data Hygiene (2)'[Safety Time]>1*'Master Data Hygiene (2)'[Red Zone Days]),0,1))

I have checked all the columns. There does not seem to be any change in the data-types. I am not sure why I am still getting this error.

But the error seems to be fixed when I use FORMAT. I do not want to use FORMAT because I get the value as text and cant be further used for calculation.

Any help would be appreciated!

Thank you!

[amitchandak · Accepted solution]

@Anonymous , Try like

Safety Stock and Safety Time Alignment = IF('Master Data Hygiene (2)'[Buffer Profile]="NB",blank(),
IF(OR(1*'Master Data Hygiene (2)'[Safety Stock]> (1 *'Master Data Hygiene (2)'[Red Zone Quantity]),(1*'Master Data Hygiene (2)'[Safety Time])>(1*'Master Data Hygiene (2)'[Red Zone Days])),0,1))

[Anonymous]

Thanks a lot! @amitchandak