Download Excel START Files: https:\/\/ift.tt\/2MqR0km
\nDownload Excel FINISHED Files: https:\/\/ift.tt\/2MfNGfr
\nDownload pdf Notes about Power Query: https:\/\/ift.tt\/2veIr4P
\nAssigned Homework:
\n Download Excel File with Homework: https:\/\/ift.tt\/2M4R2Sl
\n Example of Finished Homework: https:\/\/ift.tt\/2OjHnob<\/p>\n
In this Video learn how to use Power Query\u2019s Group By feature to Group By and create a unique list with aggregate calculations or create a Group By Report based on Consecutive Occurrences of items in a given column with aggregate calculations.
\nTopics:
\n1. (00:15) Introduction
\n2. (00:37) What is Group By Report based on Consecutive Occurrences?
\n3. (01:27) Group By feature to Group By and create a unique list with aggregate calculations
\n4. (03:15) Learn about how Gear Icon can Disappear when you alter the M Code, which means the dialog box disappears.
\n5. (05:12) Learn about the difference between Duplicating a Query and Referencing a Query.
\n6. (05:12) Group By Report based on Consecutive Occurrences of items in a given column with aggregate calculations. Use the forth argument and GroupKind.Local
\n7. (07:27) Summary
\nComprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.<\/p>\n