Advanced Group By Tricks in Power Query

===== LIVE TRAINING =====

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== CHAPTERS =====
0:00 Intro
0:19 Live Training
1:22 Group By - Concatenate values of a List
8:55 Group By - Find a Max Value Year
13:33 Live Training

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

- - - - -
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
Official After The Fall YouTube Channel Below
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)

[KawanExcel]

This guy always make me amaze with his stuff .... Thankyou chandeep... You are the best teacher ever

[fateenibrahim]

I really appreciate how you go through writing the M code step by step, coz its allowed me to break down the steps and know exactly where went wrong i.e. if i pulled a list instead of a table first for a function for tables. Thanks a lot!!

[joelabacherli]

You lead YouTube in amount of information retained per second. All of your videos pack so much information in such a short amount of time. Thank you so much for the content.

[pbiqueryous]

This has came at the PERFECT time! I've been asking myself these questions with advanced transformations for nested Tables, Lists and Records. I still have many questions - but you have again shined a bright guiding light in a world full of data darkness! Thank you bhaai-jaan!

PS: Also amazed that you InteliSense works 🤣 - and so rapidly! What is this wizardry!? 🧙🏽‍♂️

[mecorowa]

Hi, this tick with text.combine is really great. Is there a possibility to combine also numbers (with out converting to text)?
Currently I need two steps, one step in group_by: {"Single_Qty", each [Qty]}, and a 2nd step to extract the values: Extract Values from List = Table.TransformColumns(GroupedRows, {"Single_Qty", each Text.Combine(List.Transform(_, Text.From), "#(lf)"), type text})
Do you have any approach to combine it in one group_by step?
Thank and Cheers.

[kdhivyabharathi]

Hello Sir, I have a small doubt.. What is the difference between group function and aggregate function? In real time, based on which scernio we will decide to use for group by or aggregate function ?

[papettipaolo]

Thats an amazing video! Thank you for sharing! I was actually trying to do the opposite i.e transform a field with multiple value into mutiple lines with one value only per each line, any guidance?

[henryburke]

Thanks, I had a hunch that the editor could be leveraged in this way but I just started using PowerBI and did not have the language and syntax knowledge yet. Great jumpstart -Thank you!

[walter]

Simply Amazing... What a new way to get an approach to the problem....!!!

Amaizing video, thanks, with wich keys you can give format to the function in the formula bar? Like indent code or pull a row of code into the next line? thanks

[ajaypatil]

Great work chandeep 👌👍 just want to know where is practice file of this particular video. Please tell me

[jean-marcherard]

Hi Chandeep, great video.
Case 1, any hint on how would you concatenate values on 2 columns ?
afer using advanced group by in the Ui ...

[BrainyBrunetteBarbie]

I like to think of the Advanced Editor as the *true* user interface. Your videos have shown me so many new tricks! Thank you!

[mahathmasadineni]

Hi Chandeep as usal awesome vedio.
I have one doubt what if i need to get the sales for the particular year like 2004, or if need filter for one text in a column

[miazhou]

Hi man, you explain things very clearly. You surely are one of the best teachers.

[inaction]

Great video. Just one suggestion that please consider making your speaking window smaller or cropping it to only show your body, so that audiences get to see more screen. I found a few videos of yours that you were deleting/moving steps that we can’t actually see what’s been deleted and moved. Nevertheless, Thanks for making such wonderful and educational videos for free to us all here.

[pabeader]

You are the man! I did that concat a list but it took me MANY steps and helper columns. Your way is very clear and elegant. Will be replacing mine with yours.

[learningmadesimple]

Really great video... But what would you do if there were more than 1 year with the max value??

[mahimasharma]

Very informative and knowledgeable video...you clearly explained every step. Thnx for this video.

[bharatarse]

Thanks chandeep, you are making us think in different way to solve problem in Power query...that's really helpful... excellent video..👍👍