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!!
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!
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!? 🧙🏽♂️
You lead RUclips 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.
This is an absolutely perfect video and solution. That is precisely what I wanted for my issue mainly. I had been bouncing my head here and there and finally found this fantastic video. Thank you for sharing it, and keep up the excellent work.
Hi @Goodly What happens when there is a tie ? for example if two years have the same max value ? I am currently learning sql so in sql there are a windows functions called Row and Rank to deal with this level of complexity but I am not sure if we have any for M code.
Great work, man! I'm just silent! I've searched this solution for weeks, but unsuccessfully when somebody didnt suggest me do this with next step. But you did it with one professional mode! :)
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
This solution couldn't come in a better time, the concatenation suggestion solved the main issue I had with some data transformation. Thank you Chandeep. First video that I watched on your channel and definitely not the last one. Thank you once again.
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.
@@GoodlyChandeep I was able to take it one step further and added List.Sort for the items in the Concatenation. Look cleaner if the machines, in my case, are listed in order. Would not have been possible with my 'old' way of doing this. Thanks again!
You can also use the Group By and Sum the column you want to concatenate. For sure it returns an error first. But then in the formula replace List.Sum by Text.Combine and remember to complete it with the delimiter in the right place.
True, thanks for completing my answer as such avoding miscomprehension. I only wanted to point out the UI helps you discover and understand the logic behind M more then you'd realize. I often use the UI to give me a basic code that I can afterwards finetune.
Thanks Chandeep for sharing this. This is a very important topic you touched. I work more with Power Query than DAX and having the ability to do such amazing transformations helps a lot. Will play around with this.
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?
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
You are really good. Thanks for your content. I am interested in filtering and grouping each table, and then combining. I can't seem to find a video in which you do that. Can you direct me or create something new?
I don't know how many hours of work you've saved me, especially your grouped index column video. Your explanation of it was the only one I could understand clearly. : )
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.
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.
This guy always make me amaze with his stuff .... Thankyou chandeep... You are the best teacher ever
Thank you for your inspiring words 💚😊
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!!
Thanks :)
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!
Awesome man. This is exactly what I was looking for! Thank you.
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!? 🧙🏽♂️
Thanks for your nice words & also glaf it was helpful 💚
Brilliant! Thanks a lot for this and many other short practical videos you produced and shared! :)
Glad you enjoyed it!
Genius! Thanks for putting this training video out here. Great information!
Glad it was helpful!
Your videos are just fantastic - so clear and with content that is so relevant to business requirements. Thank you!
This was amazing! Love how you explain everything!
Thank you!
You lead RUclips 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.
Thanks :)
Simply Amazing... What a new way to get an approach to the problem....!!!
Dude much appreciated! Great explanation and came at a great time as well
This is an absolutely perfect video and solution. That is precisely what I wanted for my issue mainly. I had been bouncing my head here and there and finally found this fantastic video. Thank you for sharing it, and keep up the excellent work.
Glad it helped Khawar!
Hi @Goodly What happens when there is a tie ? for example if two years have the same max value ? I am currently learning sql so in sql there are a windows functions called Row and Rank to deal with this level of complexity but I am not sure if we have any for M code.
Great work, man! I'm just silent!
I've searched this solution for weeks, but unsuccessfully when somebody didnt suggest me do this with next step.
But you did it with one professional mode! :)
Cool! Glad it was helpful! 💚
Great. Thanks so much. Loved it!
Glad you love it! 💚
Thanks for the wonderful video! Very precise and useful!
Glad you like it 💚
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
Wow, this is amazing! Thank you so much for sharing - It solved one of my main problems at work!
🙋🏼♂️from 🇩🇪
Glad it was helpful!
I like to think of the Advanced Editor as the *true* user interface. Your videos have shown me so many new tricks! Thank you!
Glad it was useful 💚
You are awesome! thank you very much!
Thank you! It is exactly what i have been searching for some days!
Glad you finally found it, Gabriella!
Fantastic 💯👍
This solution couldn't come in a better time, the concatenation suggestion solved the main issue I had with some data transformation. Thank you Chandeep. First video that I watched on your channel and definitely not the last one. Thank you once again.
Excellent!
Fantastic!!! High level - but easy to understand!
Great to hear!
thanks for your video. let me further understand the lookup in power query
Mind blowing. Thanks for sharing such a fantastic feature.
Glad you like it!
Thanks Chandeep! Amazing scenarios and their solutions
I love how you breakdown approaching M coding and tweaking the code generated by powerquery
Glad you love it 💚
Thank you ! This was another great educational video.
Thank you for your really usefull tips.
Seriously, genius. 🎉
You are always awesome to come up with new learning for us. It is very helpful.
Glad it was helpful 💚
Perfect! Thanks so much!
Welcome William!
Thanks a lot. It helps with my project. Will definitely enroll in your M course
Glad to find your content. Subscribed.
Glad you have subscribed! 💚
Wowww. Awesome. Superb explanation Chandeep!
Glad you like it !
Amazing!!!!!!! thank you for sharing your knowledge!!
Glad you enjoyed it Eliseo!
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 ...
Thanks chandeep, you are making us think in different way to solve problem in Power query...that's really helpful... excellent video..👍👍
Glad it was helpful!
The more I watch the more I learn! Thanks again Chandeep!
Cool!
Brilliant!
Very informative and knowledgeable video...you clearly explained every step. Thnx for this video.
Glad you like this
Your really amazing 🥰. Love from Andhra Pradesh
Amazing👏
This is so amazingly useful !!!! And so well explained. Thank you Chandeep !!! 😁
Glad it was useful 💚
Hi man, you explain things very clearly. You surely are one of the best teachers.
Glad you think so!
So true!
You are a super Genius man !!...Thanks a lot for sharing your knowledge ! love your explanation
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.
Glad it was helpful 💚
@@GoodlyChandeep I was able to take it one step further and added List.Sort for the items in the Concatenation. Look cleaner if the machines, in my case, are listed in order. Would not have been possible with my 'old' way of doing this. Thanks again!
Wonderful data manipulation Chandeep!!
Thank You Martin! 💚
Thank you so much. This is exactly what I need.
Glad it helped
Very very useful tutorial especially because of the value it brings where the use cases are enormous in real life job situation tasks
Thanks Alex! 😃
This is again a amazing and informative Video, you are the guy from whom I learnt so much about M Language.
Thanks Kuldeep for your nice words 💚
Bro... you made my day.
Good stuff Chandeep
i learn something new from you every time
Thanks chandeep ji
Glad to hear that!
🇧🇷 One of the best Power Query codes I've seen! Congratulations!
Thank you 💚
@@GoodlyChandeep 🇧🇷 Keep up the good work, man! 👊🏻👏🏻👏🏻👏🏻🔝
You are teaching for video all very well😍.thank !
Glad you like it 💚
Great video!
Thank you!
thank you so much, thank youtube suggest what I am looking for
Thanks for the video, very informative 👍👍
Glad you like it 💚
Very helpful
You can also use the Group By and Sum the column you want to concatenate. For sure it returns an error first. But then in the formula replace List.Sum by Text.Combine and remember to complete it with the delimiter in the right place.
Not quite. You still need to create the distinct list of Customers before you can use the Text.Combine function.
True, thanks for completing my answer as such avoding miscomprehension.
I only wanted to point out the UI helps you discover and understand the logic behind M more then you'd realize. I often use the UI to give me a basic code that I can afterwards finetune.
You are really the best!!
Thank you 💚
Thanks Chandeep for sharing this. This is a very important topic you touched. I work more with Power Query than DAX and having the ability to do such amazing transformations helps a lot. Will play around with this.
Thanks for your nice words Jay! 💚
@@GoodlyChandeep And utilized it (Group By - concatenate values of a List) today on a real project as well. Thanks again!
Very good, well done.
Thank you 💚
Thanks!! I have seen similar other solution and this is the most simple and efficient. It is like 3 step only 😎
Glad you like it!
Thank you for sharing your advance tricks in PQ
Glad you like it 💚
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?
You are the best teacher of power bi😍😍
Thank you!
Excellent tutorial. You teach how to think in M Language. Thank you very much. :-)
Glad you like it 💚
Such a great content 👏
Thank you 💚
Great
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
Thanks a lot again bro, great tips
Always welcome!
You are really good. Thanks for your content. I am interested in filtering and grouping each table, and then combining. I can't seem to find a video in which you do that. Can you direct me or create something new?
This was awesome
Thank you 💚
Nicely explained sir
Thank you 💚
You are awesome.....
Thank you!
Thanks sirji🎉🎉🎉❤❤❤😊
Can you also show how to BI a Bank PDF Statement Analysis easily😮
Thanks again, Chandeep!
Thanks a lot Carl ... Appreciate the gesture :)
I don't know how many hours of work you've saved me, especially your grouped index column video. Your explanation of it was the only one I could understand clearly. : )
Thanks!
Thank you Stefan!
Thanks so much.
You're welcome!
Finished watching
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.
Thank you, Chandeep. I finally understood '_'.
Glad it was helpful to you 💚
Amazing
Thank you! 💚
Great work chandeep 👌👍 just want to know where is practice file of this particular video. Please tell me
Nice
sir is it possible to get row data for practice purpose
Good content
Thank you 💚
Is this possible to use count if function in power quary.
In number of date colum ..I want use countif(range,>0.5)
Range = number of colum..
??
great video, Chandeep. just wish you supplied your dataset to make learning easier.
All the blogs are supplied with dataset - goodly.co.in/blog/
@@GoodlyChandeep fantastic. thank you!
Genius 🙏
Thank you!
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.
I just wonder how to show both MaxSalesYears in case there were 2 or 3 years with the same max Sales Value.
I was a little confused as well because I thought we were going to SUM the sales by Year first or Sum them by customer first.
You are amazing 🤩
Thank You!
Hey can you provide the dataset ?
Very informative. Can we get the source file ?
thak you
Smart Man
Thank you 💚
Muchas Gracias Chandeep, me encantan tus videos, son muy claros y me han servido mucho!. Sigue así 👍👍
¡Me alegro de haber podido ayudar! :D