yaya1974Helper III2 years agoIF(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...Show More
Dangar332Resident Rockstar2 years agoHi, yaya1974 One of your column is type string and you compare it with non-string type column. So these problems occur so check it
yaya1974Helper III to Dangar3322 years agomy 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?
Related contentPower Query Nested IF AND StatementNested IF/AND StatementCustom column with IF and AND statementDax IF/AND Statement with Null conditionIF statement and conditions
