Power Query - List.Buffer to do a Million row Lookup
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
https://github.com/jbotes/powerbiTuto...
Noteworthy techniques
- list of lists (double list in a list)
- nested lets
List.ReplaceMatchingItems
https://powerquery.how/list-replacema...
Table.TransformColumnTypes
https://powerquery.how/table-transfor...
Text.split
https://powerquery.how/text-split/
List.Buffer
https://powerquery.how/list-buffer/