Column in Query Editor with nested if

[JuliaF]

Hi everyone,

i'm trying to create a column in query editor, using this code:

if [A] = [A.1]
&& [B] = [B.1]
&& [C] = [C.1]
then [X]
else [Y]. 

Similar code worked with the DAX column here:

New Column = IF(table[A]=table[A.1] && table[B]=table[B.1] && table[C]=table[C.1], table[X])

This is how he dat looks like:

value 1	value 2	Condition	Condition1	Condition2	Condition2	New column
x1	y1	c1	c1	e1	m1
x2	y2	c2	c2	e2	m2
x…	y…	c3…	c…	e…	m…

I want to insert the value from Value 2 if 2 or more conditions are fulfilled.

Best Regards,

Julia

[Vera_33 · Accepted solution]

Hi @JuliaF 

Change && to and, if you do have many conditions, try List.AllTrue

if List.AllTrue({[A] = [A.1],[B] = [B.1],[C] = [C.1]}) then [X]
else [Y]