Power query conditional column

[eduzs]

Is that possible to add a conditional column with such statement in Excel Power Query?

= Table.AddColumn(#"Classified rows", "Personalize", each if QueryA[MyData] = "X" and QueryB[MyData] = "Y"  then "Z" else [MyData)

Also a simplier formula like if [MyData]="1" then QueryA[MyData] return a list of values not the corresponding QueryA MyData row data.
It's not working.Thanks

 

[sandy666]

QueryA[MyData] is a List and "X" is a Value so QueryA[MyData] = "X" will be FALSE, the same with the second element
maybe post via XL2BB representative example(s), M you are using and expected result or share excel file with these example via OneDrive, GoogleDrive, DropBox or any similar service
all with detailed info what are you trying to achieve

 

[Bo_Ry]

QueryA[MyData] and QueryB[MyData] refer to the whole column [MyData] as list

You need to add index column

#"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 0, 1, Int64.Type),
custom = Table.AddColumn(#"Added Index", "Personalize", each if QueryA[MyData]{[Index]} = "X" and QueryB[MyData]{[Index]}  = "Y" then "Z" else [MyData])

 

[eduzs]

I managed to achieve the goal using append and merge queries.
Thanks all

 

[sandy666]

That's good you found a solution