Check if one value is in all tables or in one table.

Regular Contributor



I have found a solution here, but I have a feeling that there is abetter solution.


Goeal, to see if an employee have passed all 3 trainings, or one of them. 


multiple tables.PNG


Ja=Yes, Nei=No.


Example atytached.

Best Regards

- Geir

4 Replies

@Geir Hogstad 

Less elegant, but shorter:

@Geir Hogstad 

A similar problem was discussed in this video today:


Learn how to easily compare 3 or more tables in Power Query and avoid having to do lots of complicated query merges.0:33 Power Query Lists (Table Columns)1:0...
Thank you Hans, a good silution.

Thank you, I will have a look. Always good to learn.