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

%3CLINGO-SUB%20id%3D%22lingo-sub-2616546%22%20slang%3D%22en-US%22%3ECheck%20if%20one%20value%20is%20in%20all%20tables%20or%20in%20one%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2616546%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20found%20a%20solution%20here%2C%20but%20I%20have%20a%20feeling%20that%20there%20is%20abetter%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGoeal%2C%20to%20see%20if%20an%20employee%20have%20passed%20all%203%20trainings%2C%20or%20one%20of%20them.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22multiple%20tables.PNG%22%20style%3D%22width%3A%20956px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300920i564C55A3A3E4D815%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22multiple%20tables.PNG%22%20alt%3D%22multiple%20tables.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJa%3DYes%2C%20Nei%3DNo.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20atytached.%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3E-%20Geir%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2616546%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2616735%22%20slang%3D%22en-US%22%3ERe%3A%20Check%20if%20one%20value%20is%20in%20all%20tables%20or%20in%20one%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2616735%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9195%22%20target%3D%22_blank%22%3E%40Geir%20Hogstad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELess%20elegant%2C%20but%20shorter%3A%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2616903%22%20slang%3D%22en-US%22%3ERe%3A%20Check%20if%20one%20value%20is%20in%20all%20tables%20or%20in%20one%20table.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2616903%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9195%22%20target%3D%22_blank%22%3E%40Geir%20Hogstad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20similar%20problem%20was%20discussed%20in%20this%20video%20today%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DkjeR7nZ3Clw%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DkjeR7nZ3Clw%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

Hi,

 

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:

https://www.youtube.com/watch?v=kjeR7nZ3Clw

 

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.

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

/Geir