Nested functions and Table.Buffer()

Рет қаралды 18,493

3 жыл бұрын

How to properly use Table.Buffer() function when dealing with nested iterations in Power Query? You can see the explanation with an example in the video.
Link to the article on the same topic: exceed.hr/blog/nested-functio...
Check out our new Power Query fundamentals course!
exceed.hr/en/academy/powerque...
#powerquery #powerbi #etltools #data #dataanalysis

Пікірлер: 34

@maurobsn1873 3 күн бұрын

excellent, very in depth explanation!!! tnx for this great video!

@tonydreisenstock 10 ай бұрын

My only complaint not enough videos! My proficiency in PQ has increased exponentially with every video of yours that I watch. Thank you!

@damionc Жыл бұрын

Mind Blown. I was having this very issue hitting my head and cant figure out this error and problem. Thank you so much. Subscribed.

@michaelweiner6274 2 жыл бұрын

Great! Thank you for this video! It made the each concept much more clear! Microsoft should hire you to write the PowerQuery M documentation :)

@tiendinh7185 8 ай бұрын

HAHA TRUE

@felipesignorellireis7839 2 жыл бұрын

Table.Buffer Helpe me A lot. Thank You

@Alexander_Excel_Genie Жыл бұрын

Thanks sensei, been struggling with nested each for a week until came across your video, now my code seems to work, very well done!!!

@s1ngularityxd64 Жыл бұрын

thanks for sharing these awesome techniques

@dunnobe 2 жыл бұрын

Good video; you taught me aboutt 2 basic principles that I really needed to speed up my PQ.

@StefanoVerugi Жыл бұрын

very informative, one of the best video on each and outer/inner data, thank you

@GeertDelmulle 3 жыл бұрын

The nested contexts explanation could have been more terse IMHO, more emphasis on the buffering was expected. I do applaud your in-depth knowledge of Power Query. Very good!

@drewbbc7074 2 жыл бұрын

Fuzzy match will also work

@cedjulemckeever Жыл бұрын

Great and informative video. But for a novice like me, I wish you would have made the code larger or clearer. Also, if you could attach the tables, it would be helpful for us beginners. I couldn't fine the table in the Contoso tables.

@kennethstephani692 3 жыл бұрын

Great video!

@thiagobrito6892 Жыл бұрын

Appreciated that!

@skydeepdive 3 жыл бұрын

Well explained!

@ExceedLearning 3 жыл бұрын

Thanks!

@mshparber 3 жыл бұрын

Good stuff! Thanks!

@ExceedLearning 3 жыл бұрын

Thank You!

@ndrtimdauti4173 Жыл бұрын

Amazing video. Is it possible to use 2 outer variables? I need to merge based on Article nr. and contract nr. (în your case you use single variable, the product) thank you

@chakrabmonoj Жыл бұрын

Hey Sensei...thanks for a great video. It actually solved a problem that I have grappling with and I have now understood a simpler way of using the equivalent of vlookup in PQ. I was wondering if the nested function that you have used as a step here be written as a separate function altogether - I tried to do that, but the new column returns just a text giving the outer function name. And since the Outer or Inner does not specify the type of the parameter, its not choosing the tables at all if I run that function thru' "invoke". Quite possibly I am writing the script wrong - would mind sharing the script the way it would have to be if it were to be written as a stand-alone function not as a step within another query?

@rangs1966 Жыл бұрын

It is a great video. thanks I want to practice concepts. So please attach the file used by you

@eziola 2 жыл бұрын

You da man!🤜🤛

@malchicken 3 жыл бұрын

Very informative :). Is there any way to reference just a certain step within a separate query? Further explanations of other ways ‘temporary functions’ within a single steps code would be much appreciated. I know ‘keep duplicates’ button throws out some kinda complicated code that uses a temporary function inside it.

@ExceedLearning 3 жыл бұрын

Thanks! You can reference other queries in the current query, but there is no way of referencing a single step from another query. This is due to the environment in which your query works. You can reference all the steps from the current query, but not the steps from other queries.

@malchicken 3 жыл бұрын

@@ExceedLearning ah very nice, so it’s not just that idk how to do it, it’s that it can’t be done. Nice to know, thank you 👌

@JohnKpl Жыл бұрын

Thank you for explaining I am trying to reduce Power Query time to load multiple times the same CSV file (to make individual variations). With no luck Is it possible? Load once and then copy results to another tables?

@nil.hunter Жыл бұрын

What`s folding?

@petitbergerU2b 2 жыл бұрын

Hello Krešimir, I really like most of your content but this specific video and the article as well are HUGE both in terms of topics as well as in terms of didactic quality. I have been watching this multiple times (since I can't quite record every bit each time I need). Now I am writing you because I had never noticed that at timebar 5'09" you seem to be using a keyboard shortcut to do M auto-formatting for the step that you are editing. Could you PLEASE let me know what on earth is this keyboard shortcut ???

@ExceedLearning 2 жыл бұрын

Hi, thank you for your comment! I have to disappoint you with the answer to your question. :( There is no keyboard shortcut for the auto-formatting M code. It was simply a postproduction edit of the video in which we cut most of the part where I was formatting the code manually.

@eric_vieira 3 жыл бұрын

Top.top.top.....assisti umas 5x......toncom problema parecido

@alessandrodearaujosilva6028 2 жыл бұрын

Top mesmo... Estava com um problema, buscando substituir a função Table.NestedJoin e, além de substituir, ganhei performance com Table.Buffer. Parabéns!