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/jbo...
Noteworthy techniques
- list of lists (double list in a list)
- nested lets
List.ReplaceMatchingItems
powerquery.how...
Table.TransformColumnTypes
powerquery.how...
Text.split
powerquery.how...
List.Buffer
powerquery.how...
Негізгі бет Power Query - List.Buffer to do a Million row Lookup
No video
Пікірлер: 21