Forum Discussion

yaya1974's avatar
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
Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

hi, yaya1974 

 

 

use switch() function instead of IF.


like 

bucket =
switch(true(),

'Open Sales 55 7 15 3'[Over 15 Days]=true,"over 15",
'Open Sales 55 7 15 3'[6 to 15 Days]=true,"6 to 15 days past due",
'Open Sales 55 7 15 3'[0 to 5 Days]=true,"1 to 5 days past due",
and continue ........)

 

  • yaya1974's avatar
    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!!

    • Dangar332's avatar
      Dangar332
      Resident Rockstar
      2 years ago

      Hi, yaya1974 

       

      One of your column is type string and you compare it with non-string type column. So these problems occur so check it 

      • yaya1974's avatar
        yaya1974
        Helper III
        2 years ago

        my  columns that equal true/false are data type true/false and my number columns are data tpe text.

        how do I check which is string and non-string?