Deprecated: Creation of dynamic property CF\WordPress\DataStore::$logger is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php on line 23
Deprecated: Creation of dynamic property CF\WordPress\Proxy::$pluginAPI is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/Proxy.php on line 31
Deprecated: file_get_contents(): Passing null to parameter #2 ($use_include_path) of type bool is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/codelights-shortcodes-and-widgets/codelights.php on line 20
Warning: session_start(): Session cannot be started after headers have already been sent in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/wordpress/src/class/wordpress.php on line 53
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
{"id":696,"date":"2018-07-29T20:44:21","date_gmt":"2018-07-30T03:44:21","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=696"},"modified":"2018-12-02T13:11:30","modified_gmt":"2018-12-02T20:11:30","slug":"msptda-08-power-query-group-by-feature-table-group-function-5-examples","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2018\/07\/msptda-08-power-query-group-by-feature-table-group-function-5-examples\/","title":{"rendered":"MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples)"},"content":{"rendered":"Download Excel START Files:
\nhttps:\/\/ift.tt\/2veJ0vt
\nDownload Excel FINISHED Files:
\nhttps:\/\/ift.tt\/2LvyjQd
\nDownload pdf Notes about Power Query: https:\/\/ift.tt\/2veIr4P
\nAssigned Homework:
\nAssigned Homework:
\n Download Excel File with Homework: https:\/\/ift.tt\/2OmVQAN
\n Example of Finished Homework: https:\/\/ift.tt\/2AmjM4b<\/p>\n
In this Video learn all about Power Query\u2019s Group By feature. See Four Examples of how to use Group By to Calculate Total Sales, Standard Deviation, Join Names and Rank Sales.
\nTopics:
\n1. (00:15) Introduction
\n2. (01:30) What Does Power Query Group By feature do?
\n3. (02:58) Examples of PivotTable, SUMIFS, Data Model PivotTable and SQL Code to see that Power Query Group By is VERY Similar
\n4. (05:55) Example of Simple Power Query Group By Command for Total Sales
\n5. (08:50) First Look at Table.Group Power Query Function
\n6. (10:17) Example of using Group by to get Tables of Grouped Records, or Matching Records
\n7. (11:55) Standard Deviation Custom Column Based on Grouped Records Table
\n8. (14:41) Joined Text Items from Unique List formula in Custom Column Based on Grouped Records Table
\n9. (16:23) Detail look at Table.Group Function. Edit and create arguments in Third Argument to List Multiple New Columns with Formulas
\n10. (21:32) Power Query Group By to Help Rank Sales for Each Product
\n11. (26:24) Group By More Than One Column
\n12. (27:11) Fast Trick for Group By: Placeholder Function
\n13. (28:51) Add new data and see that everything updates.
\n14. (29:38) Summary
\nComprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.<\/p>\n