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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
andris_
Resolver I
Resolver I

AND() function

Hi everyone,

 

I'm trying to create a column which checks if two other columns contains some expressions. So I tried to create that column, this is how it looks like:

Column = if(AND(Text.Contains([Column1], "something"), Text.Contains([Column2], "anything"))) then "result" else "other"

 

But it is not working for me, and I have no idea why, and I couldn't find any solution for it.

 

This is the error message I got:

Expression.Error: The name 'AND' wasn't recognized.  Make sure it's spelled correctly.

 

Anybody has any idea how to solve it/make it right?

 

Thanks in advance.

1 ACCEPTED SOLUTION
LaurentCouartou
Solution Supplier
Solution Supplier

AND() is an Excel function. What you are looking for is just to use "and" as an operator.

 

Column = if Text.Contains([Column1], "something") and Text.Contains([Column2], "anything") then "result" 
else "other"

View solution in original post

6 REPLIES 6
Justas4478
Responsive Resident
Responsive Resident

I am trying to write something similar but for DAX filter.

This is what I have so far but 'and' does not seem to work.

Justas4478_0-1699347618133.png

I cant seem to find what is correct operator for 'and'.

Thanks

Maysantos
New Member

Can someone help me please with the syntax error:


Album "C" =

    var v_A = if("for Sampling"[A] = "N",1,0)

the error says: The syntax for '[A]' is incorrect. (DAX( var v_A = if("for Sampling"[A] = "N",1,0))
LaurentCouartou
Solution Supplier
Solution Supplier

AND() is an Excel function. What you are looking for is just to use "and" as an operator.

 

Column = if Text.Contains([Column1], "something") and Text.Contains([Column2], "anything") then "result" 
else "other"

Oh, I see. Thank you very much!

andris_
Resolver I
Resolver I

Hi everyone,

 

I'm trying to create a column which checks the content of 2 existing columns and if column1 contains "something" and column2 contains "anything" then "result1" else "result2".

 

This is how it looks like: Column = if(AND(Text.Contains([Column1], "something"), Text.Contains([Column2], "anything"))) then "result" else "other"

 

There is no syntax error in it, but if I try to create it, it gives me this error message: "Expression.Error: The name 'AND' wasn't recognized.  Make sure it's spelled correctly."

 

Anyone has any idea what is the problem with it?

 

Thanks in advance.

Where are you writing this?  As dax or PQL?  

 

Read "2 ways to add a column" in this post http://exceleratorbi.com.au/shaping-modelling-power-bi/

 

this task is best done in Power Query (get data). There is no and function in power query. The syntax is

 

= if [column1] = "something" and [column2] = "whatever" then "x" else "y"



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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