"Expression Error: The name"AND" wasn't recognized..." issue

[Anonymous]

I was trying to add a custom column by typing: =if (AND([Column_1]="AAA",[Column_2]="BBB"))then "XXX"else if (AND([Column_1] = "AAA", [Column_2]=OR ("CCC","DDD","EEE")))then "XXX" else if (AND([Column_1]= null, [Column_2]=OR("CCC","DDD", "EEE")))then [Column_2] else"" However, the below message popped out: "Expression Error: The name"AND" wasn't recognized..." Does anyone know how to fix it? Thank you so much!

[v-yuta-msft · Accepted solution]

@Anonymous,

In M Code, the formula should be:

= if [Column_1] = "AAA" and [Column_2] = "BBB" then "XXX" else if [Column_1] = "AAA" and List.Contains({"CCC","DDD","EEE"}, [Column_2]) then "XXX" else if [Column_1] = null and List.Contains({"CCC","DDD", "EEE"}, [Column_2]) then [Column_2] else "" 

Regards,

Jimmy Tao

[ryan_mayu]

@Anonymous

The custome column has to write in M language. You need to put AND between conditions.

e.g  if column1=xxx and column2= xxx then xxx else xxx

If you want to use DAX to create a column you should write like AND (xxx,xxx)