Write Nested Let in Power Query 

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"])

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

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

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

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.

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.

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

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

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(...... ?

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

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

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

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

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

Amazing channel!

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

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.

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

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.

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

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.

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

Great

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.

Thank you Hi Chandeep. 👍👍👍👍👍

Excelent explanation, thanks.

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

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

thanks, very easy to follow

Thank you very very much 😊

Underrated, very informative.

Hii Chandeep ...Good lesson...

Great Video, Chandeep!

Thanks a lot

Super cool..!!

Thank you sir

💯👍