AND() function

[andris_]

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.

[Justas4478]

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.

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

Thanks

[Maysantos]

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 · Accepted solution]

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"

[andris_]

Oh, I see. Thank you very much!

[andris_]

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.

[MattAllington]

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"