{"id":27283,"date":"2020-12-18T11:02:13","date_gmt":"2020-12-18T11:02:13","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?p=27283"},"modified":"2020-12-18T11:04:35","modified_gmt":"2020-12-18T11:04:35","slug":"implement-aggregate-functions","status":"publish","type":"post","link":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/","title":{"rendered":"Implement Aggregate Functions"},"content":{"rendered":"\n<p>Aggregate Functions are used when we want to mathematically combine values in your data. Now, this mathematical operation covers sum, average, maximum, count, and more. Therefore, when we combine values in the data, it&#8217;s referred to as aggregating. Also, the resulting output of the mathematical operation is an&nbsp;aggregate. Now, when Power BI service and Power BI Desktop create visualizations, they may aggregate your data. Moreover, the aggregate is just what you need, but may times we want to aggregate the values in a different way.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Types of Data<\/strong><\/h3>\n\n\n\n<p>The data is either numeric or it is not at a very basic level. <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, Power BI can aggregate numeric data using a sum, average, count, minimum, variance, and much more. Moreover, the service can even aggregate textual data, often called&nbsp;<em>categorical<\/em>&nbsp;data. <\/li><li>Secondly, special types of data, like dates, have a few of their own aggregate options: earliest, latest, first, and last.<\/li><li>Also, when creating a visualization in Power BI, the service will aggregate numeric fields (the default is&nbsp;<em>sum<\/em>) over some categorical field.&nbsp;<\/li><\/ul>\n\n\n\n<p>Steps to Change how a numeric field is aggregated<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, create a&nbsp;<strong>Clustered column chart<\/strong>&nbsp;that uses a measure and a category. <\/li><li>Secondly, in the&nbsp;<strong>Visualizations<\/strong>&nbsp;pane, right-click the measure, and select the aggregate type you need. <\/li><li>Next, your visualization is now using aggregated by average.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"ways-to-aggregate-your-data\"><strong>Ways to aggregate your data<\/strong><\/h3>\n\n\n\n<p>Some of the options that may be available for aggregating a field:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Do Not Summarize. With this option chosen, Power BI treats each value in that field separately and doesn&#8217;t summarize them. Use this option if you have a numeric ID column that the service shouldn&#8217;t sum.<\/li><li>Sum. Adds all the values in that field up.<\/li><li>Average. Takes an arithmetic mean of the values.<\/li><li>Minimum. Shows the smallest value.<\/li><li>Maximum. Shows the largest value.<\/li><li>Count (Not Blanks).&nbsp;Counts the number of values in that field that aren&#8217;t blank.<\/li><li>Count (Distinct).&nbsp;Counts the number of different values in that field.<\/li><li>Standard deviation.<\/li><li>Variance.<\/li><li>Median. Shows the median (middle) value. This value has the same number of items above and below. If there are two medians, Power BI averages them.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Steps to Create an aggregate using a category (text) field<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, drag the&nbsp;<strong>Product<\/strong>&nbsp;field into the&nbsp;<strong>Values<\/strong>&nbsp;well. The&nbsp;<strong>Values<\/strong>&nbsp;well is typically used for numeric fields. Then, Power BI recognizes that this field is a text field, sets the aggregate to&nbsp;<strong>Do not summarize<\/strong>, and presents you with a single-column table.<\/li><li>Next, if you change the aggregation from the default&nbsp;<strong>Do not summarize<\/strong>&nbsp;to&nbsp;<strong>Count (Distinct)<\/strong>, Power BI counts the number of different products. In this case, there are four.<\/li><li>Then, and if you change the aggregation to&nbsp;<strong>Count<\/strong>, Power BI counts the total number. In this case, there are seven entries for&nbsp;<strong>Product<\/strong>.<\/li><li>Lastly, by dragging the same field (in this case&nbsp;<strong>Product<\/strong>) into the&nbsp;<strong>Values<\/strong>&nbsp;well, and leaving the default aggregation&nbsp;<strong>Do not summarize<\/strong>, Power BI breaks down the count by product.<\/li><\/ul>\n\n\n\n<p>For more details visit <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-aggregates\" target=\"_blank\" rel=\"noreferrer noopener\">Work with aggregate functions (sum, average, and so on) in the Power BI service<\/a><\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.testpreptraining.ai\/microsoft-power-platform-fundamentals-pl-900-free-practice-test\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.png\" alt=\"Microsoft Exam PL-900 Free Practice Test\"\/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Aggregate Functions are used when we want to mathematically combine values in your data. Now, this mathematical operation covers sum, average, maximum, count, and more. Therefore, when we combine values in the data, it&#8217;s referred to as aggregating. Also, the resulting output of the mathematical operation is an&nbsp;aggregate. Now, when Power BI service and Power&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-27283","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Implement Aggregate Functions - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Boost your chances to qualify Microsoft Power Platform PL-900 Exam with Free Practice Test. Learn about Aggregate Functions Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Implement Aggregate Functions - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Boost your chances to qualify Microsoft Power Platform PL-900 Exam with Free Practice Test. Learn about Aggregate Functions Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-18T11:02:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-18T11:04:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.png\" \/>\n<meta name=\"author\" content=\"Testprep Training\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Testprep Training\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/\"},\"author\":{\"name\":\"Testprep Training\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/person\/dd77de7629ccca38189dc6f36b797165\"},\"headline\":\"Implement Aggregate Functions\",\"datePublished\":\"2020-12-18T11:02:13+00:00\",\"dateModified\":\"2020-12-18T11:04:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/\"},\"wordCount\":537,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/\",\"name\":\"Implement Aggregate Functions - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-12-18T11:02:13+00:00\",\"dateModified\":\"2020-12-18T11:04:35+00:00\",\"description\":\"Boost your chances to qualify Microsoft Power Platform PL-900 Exam with Free Practice Test. Learn about Aggregate Functions Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Implement Aggregate Functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/person\/dd77de7629ccca38189dc6f36b797165\",\"name\":\"Testprep Training\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g\",\"caption\":\"Testprep Training\"},\"description\":\"Testprep Training offers a wide range of practice exams and online courses for Professional certification exam curated by field experts and working professionals. Evaluate your skills and build confidence to appear for the exam.\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/author\/amithighpixel-in\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Implement Aggregate Functions - Testprep Training Tutorials","description":"Boost your chances to qualify Microsoft Power Platform PL-900 Exam with Free Practice Test. Learn about Aggregate Functions Now!","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:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/","og_locale":"en_US","og_type":"article","og_title":"Implement Aggregate Functions - Testprep Training Tutorials","og_description":"Boost your chances to qualify Microsoft Power Platform PL-900 Exam with Free Practice Test. Learn about Aggregate Functions Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/","og_site_name":"Testprep Training Tutorials","article_published_time":"2020-12-18T11:02:13+00:00","article_modified_time":"2020-12-18T11:04:35+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.png"}],"author":"Testprep Training","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Testprep Training","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/#article","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/"},"author":{"name":"Testprep Training","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/person\/dd77de7629ccca38189dc6f36b797165"},"headline":"Implement Aggregate Functions","datePublished":"2020-12-18T11:02:13+00:00","dateModified":"2020-12-18T11:04:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/"},"wordCount":537,"commentCount":0,"publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/","name":"Implement Aggregate Functions - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-12-18T11:02:13+00:00","dateModified":"2020-12-18T11:04:35+00:00","description":"Boost your chances to qualify Microsoft Power Platform PL-900 Exam with Free Practice Test. Learn about Aggregate Functions Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-aggregate-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Implement Aggregate Functions"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/person\/dd77de7629ccca38189dc6f36b797165","name":"Testprep Training","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g","caption":"Testprep Training"},"description":"Testprep Training offers a wide range of practice exams and online courses for Professional certification exam curated by field experts and working professionals. Evaluate your skills and build confidence to appear for the exam.","url":"https:\/\/www.testpreptraining.ai\/tutorial\/author\/amithighpixel-in\/"}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/posts\/27283","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=27283"}],"version-history":[{"count":3,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/posts\/27283\/revisions"}],"predecessor-version":[{"id":27288,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/posts\/27283\/revisions\/27288"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=27283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=27283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=27283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}