add a column in Query Editor to look up two different columns

[Anonymous]

Hi  Do you know how to add a conditional column in Power BI Query Editor with the comparison condition that if the value in the left column (ColumnA) also exists in the right column (ColumnB), return to "yes" if otherwise "no".

ColumnA      ColumnB             ColumnResult

aaa                 null                           yes

bbb                ggg                            no

ccc                   aaa                           no

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Add two custom column, finally, you can delete the "Custom" column, only keep the "Custom.1" column.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

thank you very much