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 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.
 
Need Help
Show and Tell

5 Replies

  • 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?