The trick here is to use two Power Query functions "Table.ToColumns" to convert the table to Lists. And "List.Intersect" to return the most common values in the lists. Thanks to @LeilaGharani for the lesson
Пікірлер: 4
@jazzista1967 Жыл бұрын
What a nice trick!
@crispexcel Жыл бұрын
glad you found it hepful
@jazzista1967 Жыл бұрын
Crispo. I have been following you on linkedin for months. I am glad you have a channel which i was not aware of. Regards