Conditional Column with values from 2 tables

[Ronnie7]

Hello,

I need to create a conditional column in the query editor ( that is, before the data is being fed into the model), based on values from two tables.

I know that the conditional column is good for values from one tables.

What would be they way to do so for values from two different tables?

For example (if [table1.col_name] = "x"  and [table2.col_name]="y" then...

Thanks!

[Sean]

@Ronnie7

If you insist on doing this in the Query Editor I think you'll have to Merge the Queries

before you can compare the values - but we may have to check with @ImkeF about this???

Look here

http://www.excelguru.ca/blog/2015/12/16/merge-tables-using-outer-joins-in-power-query/

and also

http://www.excelguru.ca/blog/2015/12/23/merge-tables-using-inner-and-anti-joins-in-power-query/

Hope this helps!

[ImkeF]

Agree with @Sean.

I think that @Ronnie7 's question has an unspoken implication in it: That the matching values from the 2 columns have a common row-indicator 🙂

Which is normally not the row-number, but a matching attribute-value.

So as we don't have a data-model in the query-editor where the filters propagate, we need to join the tables on their common attributes in order to return meaningful data.