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/
10 мар 2024