Power Query - List.Buffer to do a Million row Lookup
ฝัง
- เผยแพร่เมื่อ 10 มี.ค. 2024
- In this video i show you how to do a composite key lookup with a million rows of data using List.Buffer.
#dataanalytics #data #datatransformation #mquery #powerbi #powerquery #powerbidesktop #excel #exceltips
File Link
github.com/jbotes/powerbiTuto...
Noteworthy techniques
- list of lists (double list in a list)
- nested lets
List.ReplaceMatchingItems
powerquery.how/list-replacema...
Table.TransformColumnTypes
powerquery.how/table-transfor...
Text.split
powerquery.how/text-split/
List.Buffer
powerquery.how/list-buffer/
Muito bom
Thanks for this, hope to see more content about List.Buffer & Table.Buffer.
Excellent! I couldn’t be more happier to discover your channel!
Each of your videos is a great lesson!
Thanks a lot!
Your content is awesome. I'm learning so much and becoming more aware of the possibility of PQ!
Back with the Bang, Thank you
Excellent as always! Thanks James.
Awesome. Thank you sensei
Amazing video as usual
You crazy ❤😊
Nice! I saved this video =) it will come in handy
List.buffer is cool....
This is great thanks!
Wow
Awsom, 👌👌 , you are amazing, Kindly do more videos on List Functions.
Thank you, I will
Will it improve List accumulate function as well if we have a similar list or records?