IF(And statements

[yaya1974]

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 days past due",if(and('Open Sales 55 7 15 3'[Promise Month]='Open Sales 55 7 15 3'[Next Month],'Open Sales 55 7 15 3'[Promise Year]='Open Sales 55 7 15 3'[Year],"next month",if(and('Open Sales 55 7 15 3'[Promise Month]='Open Sales 55 7 15 3'[Next Month]-1,'Open Sales 55 7 15 3'[Promise Year]='Open Sales 55 7 15 3'[Year]),"this month","future")))))))))

my column is bucket and I am trying to get powerbi to bring me back texts if certain column is true, it works in excel but now powerbi.  can someone please help me?

telling me too many arguments were passed to the AND function.  the maximum argument count for the function is 2.

[yaya1974]

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?

[Dangar332]

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]

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]

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]

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?