Write Nested Let in Power Query

[@sf5028]

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.

[@GoodlyChandeep]

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

[@notesfromleisa-land]

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.

[@sarahdeschene3152]

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.

[@larmondoflairallen4705]

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

[@bagnon]

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

[@GoodlyChandeep]

Brilliant! I did not know this

[@faruksedef]

What a great guy you are. A KZbinr who can say "I did not know this". @@GoodlyChandeep

[@pk5134]

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

[@GoodlyChandeep]

Sure will add those videos to my list. Cheers

[@kebincui]

Thank you Hi Chandeep. 👍👍👍👍👍

[@9zQx86LT]

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

[@lindalai1406]

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

[@GoodlyChandeep]

Thank you! Will do!

[@sukhomoyb]

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

[@aahanavikram07]

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

[@GoodlyChandeep]

Thank you so much 😀

[@alterchannel2501]

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

[@kennethstephani692]

Great Video, Chandeep!

[@KuldeepSingh-nq1vi]

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

[@GoodlyChandeep]

Glad you enjoyed & learnt it 😊

[@KgasS]

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

[@tyler2973]

Underrated, very informative.

[@cacharmidoshi2774]

Hii Chandeep ...Good lesson...

[@roncruiser]

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

[@shivammishra34]

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

[@GoodlyChandeep]

Not sure, haven't tested that!

[@wayneedmondson1065]

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

[@GoodlyChandeep]

Thank you! Cheers!

[@garynewman457]

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.

[@Negruchina2010]

Excelent explanation, thanks.

[@GoodlyChandeep]

Glad you like it!

[@radon8452]

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

[@realpulsecoin]

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 🙏

[@realpulsecoin]

Yes, just take the table back into PQ with for example ExcelCurrentworkbook(), change table to list, add filter. Works nice when you know the files you are using is static. PQ only run on new files in folder!

[@phugia8367]

thanks, very easy to follow

[@GoodlyChandeep]

Glad it was helpful 😊

[@williamarthur4801]

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.

[@realpulsecoin]

Amazing channel!

[@GoodlyChandeep]

Glad you enjoy it!

[@ChandrashekharKenchugundi]

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

[@holahandstrom]

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

[@mitultank7872]

Thank you very very much 😊

[@GoodlyChandeep]

💚

[@ajieapen]

Super cool..!!

[@rahulshewale9206]

Thank you sir

[@thebhaskarjoshi]

Thanks a lot

[@GoodlyChandeep]

💚

[@aniketsharma7307]

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

[@GoodlyChandeep]

Update your Excel!

[@SamehRSameh]

Need more about m language

[@faridPQ]

Great

[@sandeepl2304]

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.

[@rrrraaaacccc80]

💯👍

[@GoodlyChandeep]

Thanks!