Excel Magic Trick 1420

Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns

DESCRIPTION

See how to connect to an SQL Database, Append an Excel Table to the SQL Imported Data, Group By to add Total Units for each Product, then Sort, Grouping, Indexes and Custom Columns to Rank Total Product Units:
(00:14) Introduction of whole project
(01:29) Connect to an SQL Database that contains over 7 million records
(02:47) Import Excel Table
(03:25) Append an Excel Table to the SQL Imported Data
(04:06) Group By feature to add Total Units for each Product
(05:01) Sort, Grouping, Indexes and Custom Columns to Rank Total Product Units
(11:54) Change Data and Refresh
(12:30) Summary

WORKBOOKS

Download “Excel Magic Trick 1416-1420” Excel-Magic-Trick-1416-1420.zip – Downloaded 72 times – 4 MB







Be the first to comment

Leave a Reply