Easily Compare Multiple Tables in Power Query

Описание к видео Easily Compare Multiple Tables in Power Query

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:02 Checking Source Data
1:30 Load Table Into Power Query (Connection Only)
2:30 Using #shared to Create Function Reference Table
3:20 List.Intersect
4:28 Filtering Table Using Table.SelectRows and List.ContainsAny
6:33 List.Union
8:13 List.Difference

Download the Excel file that includes the data and queries in this video: https://www.myonlinetraininghub.com/e...

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn:   / myndatreacy  

Комментарии

Информация по комментариям в разработке