Thank you - this was a fantastic tutorial, very succinct yet explained everything fully. I love how you replicate the user experience of doing the thing, seeing it's not exactly what you want (e.g. the number error), and then fixing it... instead of 'knowing' in advance and building-in the preemptive steps, which can be harder to follow and easier to forget.

Your teaching style is very good---most particularly going about it as a novice would (with the text error messages). This really solidifies the learning when you show what goes wrong and how to fix. Thank you.

Amazing. I would have never imagined you could do all that inside a custom column.

I just did this in the step by step long form way you described in the beginning of the video. Glad to see a simpler way to address it. Trying to reduce the number of steps in my M query code. This will help.

Thank you Hi Chandeep. 👍👍👍👍👍

Underrated, very informative.

Wow 😲 Chandeep! Very Nice I enjoyed it and learnt one more new thing.

Hi Chandeep, I came across your channel only very recently and found it to be very helpful ! Thanks for all the content ! Could you please do a video on Power Query custom functions and on field access operators ? Specifically on how and when the "_" and "each" operators are used

Simply great... Every video of yours is taking me to next level 👍👍

Excelent explanation, thanks.

wow, that is so good. I am very happy to have found your channel. Thank you and please keep the good work!

Date variable must have been Day not Date 😅. Thank you so much for your videos. Very informative channel

Great Video, Chandeep!

thanks, very easy to follow

Good one. another alternative is Column from examples which is like flashfill in excel.

Amazing channel!

Hi Chandeep. Great video and technique! Good lesson on how to take things to the next level. Thanks for sharing :)) Thumbs up!!

I'm sure you know this already but for converting dates in weird formats, you can use this function: =DateTime.FromText([Date], [Format="yyyyMMdd", Culture="en-US"])

Hii Chandeep ...Good lesson...

Very useful. I was able to change my xa date format of yyymmdd into a proper date without all the steps of splitting the column, merging and changing the type. I have a table with numerous date fields. Is then an elegant way of applying this across all those columns.

Super cool..!!

Thank you very very much 😊

Thank you sir

Thank you. Excellent. Simplified explanation. Can this also be considered a nested function?

Thanks a lot

Hi Chandeep. Great tips and technique! However, I am keen to know the benefit of this technique over the multi-step approach.

Hi Chandeep Paaji, it's my request kindly make a video on custom nested iterator functions, where we use multi variables. Clarify this concept.

This is awesome! I always wanted to shorten my steps.. quick question... how to write a nested join statement in pq? like if I have to do multiple joins with multiple columns against multiple tables? would be like... Table.NestedJoin(Table.NestedJoin(...... ?

Great

It's always interesting to see what working solution 'Column From Examples' comes up with - since it's usually not what I would do.

Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/

Thanks a lot for simplifying this for us. Just wanted to confirm if it reduces the query cost for model refresh.

💯👍

Hi Chandeep, how to use nested each function with nested let

Question: If I import from folder, is it possible to filter the PQ so it only runs the quary that is not already imported? I have a heavy PQ, and a lot files in the folder, and it takes ages! Thanks for any answers 🙏

Need more about m language

Really good intro, but I get stuck when I try to use the advanced editor, and am a bit unclear as to the rules for nesting let and in statements, it's fine as long as addcolumns is doing it for me but often end up in a mess with when using editor, I remember on the generate dates video where you declared the start date as a variable, fine in AddColumns, but when tried to replicate in editor, Suddenly where did it have to go? trial and error once again. Sorry sound bit negative I really enjoy your work.

Thanks. What If I did not have the day on my date but just year and month ( 202104)yyyymm. But now I want to give month end date.

When I type any function then dosnt show help or suggestions like Text.From and not coloring even