Forum Discussion

yaya1974

Helper III

2 years ago

IF(And statements

Bucket = if(AND('Open Sales 55 7 15 3'[Over 15 Days]=true,"over 15",IF(and('Open Sales 55 7 15 3'[6 to 15 Days]=true,"6 to 15 days past due",IF(and('Open Sales 55 7 15 3'[0 to 5 Days]=true,"1 to 5 d...

Need Help

Show and Tell

yaya1974

Helper III

2 years ago

Hi. I actually was just trying that. it seems to work, but got error now that states:

DAX comparison operations do not support comparing values of type True/False with value of type Text. Considering using VALUE or FORMAT function to convert one of the values.

Have any suggestions?

Thanks so much!!