{"id":182645,"date":"2024-03-20T04:13:00","date_gmt":"2024-03-20T03:13:00","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=182645"},"modified":"2024-03-10T17:52:30","modified_gmt":"2024-03-10T16:52:30","slug":"power-query-aggregation-how-does-it-work","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work","title":{"rendered":"Power Query aggregation: how does it work?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"182645\" class=\"elementor elementor-182645\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5100f90 e-flex e-con-boxed e-con\" data-id=\"5100f90\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7e1a438 elementor-widget elementor-widget-heading\" data-id=\"7e1a438\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">In the age of Big Data, the problem is no longer access to data, but understanding it. And with good reason: the sheer volume of data means that many organizations no longer know what to do with so much information, this is where Power Query aggregation comes into place.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a96716f elementor-widget elementor-widget-text-editor\" data-id=\"a96716f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Fortunately, there are several solutions to simplify the understanding and management of this data. One of these is <strong>Power Query aggregation<\/strong>. Find out what it&#8217;s all about, why it&#8217;s useful for businesses, and above all, what you need to do to <strong>aggregate data with this query editor.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-31847ee e-flex e-con-boxed e-con\" data-id=\"31847ee\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-41f1bbc elementor-widget elementor-widget-heading\" data-id=\"41f1bbc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What's the point of Power Query aggregation?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-02a9314 elementor-widget elementor-widget-text-editor\" data-id=\"02a9314\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>As a reminder, Power Query is a query editor for importing and modifying data, whatever its source or format. This is equally true for <strong>Excel and Power BI<\/strong> users.<\/p><p>Data aggregation in<strong> Power Query<\/strong> is just one of the many features of this query editor. It allows you to group and summarize data, making it easier to read and manage.<\/p><p>In doing so, you can obtain additional information, <a href=\"https:\/\/datascientest.com\/en\/isolation-forest-how-do-you-detect-anomalies-in-a-dataset\">enrich your datasets,<\/a> improve your reports, identify patterns, trends or anomalies, and also reduce the risk of errors and inaccuracies.<\/p><p>Aggregating data is particularly useful when dealing with large <a href=\"https:\/\/datascientest.com\/en\/datasets-top-5-places-to-find-quality-datasets\">datasets<\/a>. And yes, by summarizing massive raw data into smaller datasets, you can more easily analyze them and draw relevant conclusions.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e969ee2 e-flex e-con-boxed e-con\" data-id=\"e969ee2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9aa6134 elementor-widget elementor-widget-heading\" data-id=\"9aa6134\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I use Power Query aggregation?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f64e41 elementor-widget elementor-widget-heading\" data-id=\"4f64e41\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Aggregate a column of data in Power Query<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e6e6fa6 elementor-widget elementor-widget-text-editor\" data-id=\"e6e6fa6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>With<a href=\"https:\/\/datascientest.com\/en\/power-query-what-is-it-whats-it-for\"> Power Query<\/a>, you can aggregate one or more columns from a linked table. For example, you could add to a price column, the sum of the unit prices for each order, the average of these unit prices, the minimum amount, the maximum amount, and so on.<\/p><p>To use<strong> Power Query aggregation<\/strong> with Excel, follow the steps below:<\/p><ul><li>In the &#8220;Home&#8221; tab, select &#8220;New source&#8221;, then &#8220;Other sources&#8221;, and the data source you need.<\/li><li>A dialog box appears. Enter the URL of the table in which you wish to aggregate a column.<\/li><li>Click on OK.<\/li><li>In the &#8220;Browser&#8221; tab, select the table you wish to aggregate (you&#8217;ll be able to preview the data on the right).<\/li><li>Click on &#8220;Transform data&#8221;.<\/li><li>This brings up the Power Query editor. Scroll to the right until you see the column you wish to aggregate. Then click on the expansion icon to the right of the column.<\/li><li>In the inset, select the &#8220;Aggregate&#8221; option, then an aggregation function item. Then choose one or more aggregation functions, such as sum, minimum, maximum, average&#8230;<\/li><li>Click on OK.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a8fc9c elementor-widget elementor-widget-text-editor\" data-id=\"4a8fc9c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Through these<strong> aggregation function elements<\/strong>, you can see the sum, minimum, maximum, average and so on.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-796959a elementor-widget elementor-widget-image\" data-id=\"796959a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-Power-Query1.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f938bd9 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"f938bd9\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Training in Power Query<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75e2b1e elementor-widget elementor-widget-heading\" data-id=\"75e2b1e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Grouping data with Power Query<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aead3e4 elementor-widget elementor-widget-text-editor\" data-id=\"aead3e4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Through <strong>data grouping<\/strong>, you can view data at a higher (or aggregated) level.<\/p><p>Here&#8217;s how to do it:<\/p><ul><li>In the &#8220;Home&#8221; tab of the Power Query editor, click on &#8220;Group&#8221;.<\/li><li>A window appears where you can select one or more variables by which you wish to group your data.<\/li><li>If you wish to group data by several variables, or perform an operation on several variables, choose the &#8220;Advanced&#8221; option. Otherwise, the &#8220;Basic&#8221; option is sufficient.<\/li><li>Choose from several options for your data output:<\/li><li>Name your aggregated column on Power Query ;<\/li><li>Choose an aggregation function (sum, average, minimum, maximum&#8230;);<\/li><li>Select the column and click OK.<\/li><li>Then click on &#8220;Close and Download&#8221; to move the data to the spreadsheet.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-90ac6c9 elementor-widget elementor-widget-text-editor\" data-id=\"90ac6c9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Through these aggregation function elements, you can see the sum, minimum, maximum, average and so on.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Excel VBA: How to automate tasks with this language&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\" target=\"_blank\" rel=\"noopener\">Excel VBA: How to automate tasks with this language<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Pie Chart Excel: Mastering Data Visualization &quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/mastering-data-visualization-a-deep-dive-into-pie-charts-in-excel\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/mastering-data-visualization-a-deep-dive-into-pie-charts-in-excel\" target=\"_blank\" rel=\"noopener\">Pie Chart Excel: Mastering Data Visualization <\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Creating Stunning Excel Charts: A Step-by-Step Guide&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/creating-stunning-excel-charts-a-step-by-step-guide\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/creating-stunning-excel-charts-a-step-by-step-guide\" target=\"_blank\" rel=\"noopener\">Creating Stunning Excel Charts: A Step-by-Step Guide<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Efficient Excel Data Formatting Based on Cell Values&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/efficient-excel-data-formatting-based-on-cell-values\" target=\"_blank\" rel=\"noopener\">Efficient Excel Data Formatting Based on Cell Values<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8713c77 elementor-widget elementor-widget-heading\" data-id=\"8713c77\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Search for data associated with a column<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0b725a3 elementor-widget elementor-widget-text-editor\" data-id=\"0b725a3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In addition to aggregating data, you can also display the data source. This will show you where the data comes from.<\/p><p>Here&#8217;s how to do it:<\/p><ul><li>In the &#8220;Query parameters&#8221; tab, select &#8220;Source&#8221; (which appears under &#8220;Applied steps&#8221;), then click on the parameters icon.<\/li><li>The &#8220;Source&#8221; dialog box appears. Make a note of the data source name, as you&#8217;ll need it later. <br \/>Return to the &#8220;Home&#8221; tab, then click on &#8220;Sources&#8221;. At this point, select the data source you noted earlier.<\/li><li>The &#8220;Navigator&#8221; dialog box appears, listing all the tables in the data source. Select only the associated table of interest. In the preview, you can also display only the relevant columns using the display options.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f130fef elementor-widget elementor-widget-text-editor\" data-id=\"f130fef\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Would you like to <strong>master Power Query<\/strong> and its various queries? The only solution is training. DataScientest offers training courses that combine theory and practice, so you&#8217;ll be up and running by the end of the course.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0751bf2 e-flex e-con-boxed e-con\" data-id=\"0751bf2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5045c6e elementor-widget elementor-widget-heading\" data-id=\"5045c6e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Things to remember :<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b3eaaee elementor-widget elementor-widget-text-editor\" data-id=\"b3eaaee\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li style=\"font-weight: 400;\" aria-level=\"1\">Power Query&#8217;s aggregation option lets you group and summarize data.<\/li><li style=\"font-weight: 400;\" aria-level=\"1\">This feature is particularly useful for data experts dealing with large volumes of data.<\/li><li style=\"font-weight: 400;\" aria-level=\"1\">Depending on your needs, you can display sums, averages, minimums, maximums&#8230; of numerical data linked between several tables.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c2497e4 elementor-widget elementor-widget-image\" data-id=\"c2497e4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Agregation-Power-Query2.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-52267a4 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"52267a4\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Start a Power Query training<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-68d26fa e-flex e-con-boxed e-con\" data-id=\"68d26fa\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5eb860f elementor-widget elementor-widget-html\" data-id=\"5eb860f\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What's the point of aggregation in Power Query?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"As a reminder, Power Query is a query editor for importing and modifying data, whatever its source or format. And it's available to both Excel and Power BI users.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How do I aggregate data in Power Query?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"On Power Query, it's possible to aggregate one or more columns from a linked table. For example, you could add to a price column, the sum of unit prices for each order, the average of these unit prices, the minimum amount, the maximum amount, etc.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>In the age of Big Data, the problem is no longer access to data, but understanding it. And with good reason: the sheer volume of data means that many organizations no longer know what to do with so much information, this is where Power Query aggregation comes into place. Fortunately, there are several solutions to [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":182648,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power Query aggregation: how does it work?<\/title>\n<meta name=\"description\" content=\"This guide provides insights into the functionality of Power Query aggregation, its syntax, and practical examples to\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query aggregation: how does it work?\" \/>\n<meta property=\"og:description\" content=\"In the age of Big Data, the problem is no longer access to data, but understanding it. And with good reason: the sheer volume of data means that many\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-20T03:13:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-10T16:52:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/03\/Agregation-Power-Query-1024x512-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Power Query aggregation: how does it work?\",\"datePublished\":\"2024-03-20T03:13:00+00:00\",\"dateModified\":\"2024-03-10T16:52:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work\"},\"wordCount\":823,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work\",\"url\":\"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work\",\"name\":\"Power Query aggregation: how does it work?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-03-20T03:13:00+00:00\",\"dateModified\":\"2024-03-10T16:52:30+00:00\",\"description\":\"This guide provides insights into the functionality of Power Query aggregation, its syntax, and practical examples to\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power Query aggregation: how does it work?","description":"This guide provides insights into the functionality of Power Query aggregation, its syntax, and practical examples to","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work","og_locale":"en_GB","og_type":"article","og_title":"Power Query aggregation: how does it work?","og_description":"In the age of Big Data, the problem is no longer access to data, but understanding it. And with good reason: the sheer volume of data means that many","og_url":"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-03-20T03:13:00+00:00","article_modified_time":"2024-03-10T16:52:30+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2024\/03\/Agregation-Power-Query-1024x512-2.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Power Query aggregation: how does it work?","datePublished":"2024-03-20T03:13:00+00:00","dateModified":"2024-03-10T16:52:30+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work"},"wordCount":823,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work","url":"https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work","name":"Power Query aggregation: how does it work?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-03-20T03:13:00+00:00","dateModified":"2024-03-10T16:52:30+00:00","description":"This guide provides insights into the functionality of Power Query aggregation, its syntax, and practical examples to","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/power-query-aggregation-how-does-it-work"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/182645"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=182645"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/182645\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/182648"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=182645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=182645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=182645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}