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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.