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

     

     

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

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks a lot! amitchandak