Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
yaya1974
Helper III
Helper III

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.
 
5 REPLIES 5
yaya1974
Helper III
Helper III

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
Super User
Super User

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 ........)

 

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!!

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 

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?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.