Summarizing Data with Group By in Power Query

Показать описание

★ Want to automate Excel? Check out our training academy ★

★ Check out the blog post & download the example file★

★ About this video ★
In Excel, there are many ways to group and summarize data, and in Power Query Group By performs this task similarly to Excel functions, but with a slightly different purpose. In Excel, we generally summarize to display a result; however, in Power Query, we summarize to reduce data to the optimal granularity level. The Power Query Group By transformation is simple yet powerful. So, let's take a look at how we can use it.

0:00 Introduction
0:52 Group By views: basic and advanced
2:06 Summarize Data: Example #1
2:56 Summarize Data: Example #2
4:08 Summarize Text
6:02 All Rows option
6:55 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel #PowerQuery

Excel Off The Grid

Рекомендации по теме

Комментарии

This was super helpful for a project I recently did. Thanks for sharing, really appreciate it.

marckirsch

The last case of "All rows" is very interesting. Excellent and brilliant explanation Mark. Thanks!!

IvanCortinas_ES

Well done! Excellent presentation, as I learned something new. Thanks!

c.e.bingham

Your content is excellent. You are very didactic. Thank you!!

Pradonis

Great video Sir!,

Just to confirm: is this "Group By" feature, the equivalent to use the SUMMARIZE() DAX expression?

angelmaravilla

Another excellent video Mark. I was previously aware of the Text.Combine trick but was plagued by the duplicate values in the cell. You made my day today with the List.Distinct() addition.

Since the need for summarizing text is quite common, do you think Microsoft will add that as an option instead of forcing us to use the Sum workaround as you present?

Picla_Peremohy

Excellent. I have a question: is possible Create groups for specific dates ? Example: my field date is day by day but I need group by month (Sum values) and March I need day by day 😅 thanks

Charly_MC

how can I apply Group by where I have multıple colums? product X Y Y sum for each months seperately ?

orkunakar

Hello sir...if my data have Duplicated on one column and I need to make a group by by this column to be unique data for my file

eslamfahmy

Using the Text.combine, the resulting column still shows errors - how do you fix that?

leiterservices

Summarizing Data with Group By in Power Query

Summarizing Data with Group By in Power Query

Group by and Summarise functions in R programming - use the tidyverse package to wrangle your data

GROUP BY Clause (SQL) - Summarize Results into Groups

Grouping and Summarizing Data Using dplyr

Data Wrangling In R with group_by() and summarise()

SQL Databases For dplyr Users: Grouping And Summarizing Data Using GROUP BY

SQL Group By: An Explanation and How To Use It

Differences between GROUPBY and SUMMARIZE

Python Tutorial: Grouping and summarizing data

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

How to aggregate data in R - summarize data by groups

GROUP your data using SUMMARIZE DAX Function in Power BI // DAX Basics for Beginners in 2022

3 PivotTable Grouping Tricks to Summarize Data FAST!

How to summarize data using GROUPBY. Would you use this new function?! 🤓 #excel #tutorial

Using dplyr's group_by function with and without summarize (CC233)

SQL Tutorial: Aggregations - summarizing data

Would You Use This New GROUPBY Function for Summarizing Data?! 🤓

Grouping and Summarizing Data with dplyr Verbs

DAX - SUMMARIZE Vs. GROUPBY in PowerBI

GROUPBY vs SUMMARIZE in Power BI || Difference between GroupBy & Summarize || Power BI Tutorial

R Tutorial: Grouping and summarizing

Summarizing Data Using PivotTables in Microsoft Excel

Summarize data EASILY with the GROUPBY function in Excel!

dplyr::group_by() | How to use dplyr group by function | R Programming