Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Error

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!
 
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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))

     

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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))