compare 2 columns from 2 fact tables

[bboy0009]

Hi guys,

I have 2 Facts tables (A and B) which have a same column TransactionCode. I would like to know , for each line, if TransactionCode of the table A has a same value in the column TransactionCode of the table B. If there is not match, I would like to display these transaction in a visual. 

I can not create a relationship between A and B.  

I'll take every solution, from Power Query or dax 🙂

Thank you and have a nice day !

[Anonymous · Accepted solution]

Hi @bboy0009 , 

Please refer to my steps.

Merge queries as new.

Then add an conditional column.

If I have misunderstood your meaning, please provide more details with the desired output and pbix file without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bboy0009]

I thought about compare each transaction of A to a list of all transaction of B and if the list contains then add "Yes" in the new column in the table A. I'm searching how to do this in M and it's kind of complicated