Download Excel File: [ Ссылка ]
Buy M Code Book at Mr Excel site: [ Ссылка ] or Amazon: [ Ссылка ] Mike "excelisfun" Girvin's 4th book: The Transformative Magic of Power Query M Code in Power BI & Excel. Book about Power Query M Code to help data analysts transform and shape data into useful, actionable information for decision makers.

Topics in Video:
1) (00:00) Introduction
2) (00:55) Worksheet function to create column of employee names from a table using TOCOL and UNIQUE functions.
3) (01:30) Worksheet function to lookup manager names and join with a comma between each name using the IF and TEXTJOIN functions.
4) (03:41) Links to buy new excelisfun Mike Girvin M Code book
5) (03:57) Power Query Solution. Keyboard to import Excel Table into Power Query Editor
6) (04:42) UnPivot to create a proper data table
7) (06:22) Group By to gather manager names into a table.
8) (07:00) Why to remove spaces from identifier names
9) (08:01) Edit Table.Group Function to extract a column from a table as a list using the Field Access Operator.
10) (08:10) What does M Code syntax Underscore mean?
11) (09:22) Text.Combine function
12) (10:23) Look at let expression
13) (11:03) Summary
14) (11:20) Closing and video links ()

#Excel, #PowerQuery #Mcode

свернуть