Playing with some list functions in power query, including List Accumulate.
List Accumulate is basically a double-looper function, with all the nice and dangerous things that implies.
00:00 List from a table column
00:32 Make a list using curly brackets
00:46 x .. y-syntax
01:46 List with all Danish letters
01:54 List Split
02:29 Referring to a list by index
02:48 List Difference
03:36 List Intersect
04:10 List Union
04:40 List Zip
05:30 List Random
06:02 List Select
06:46 List Range
07:21 List Position
08:05 List Insert
09:52 List Alternate (is weird)
11:18 List Generate, is a Do While-loop
13:24 List Generate, count down
14:22 Create a calendar-table with List Generate
17:54 List Transform
18:27 List Transform Many (is very weird)
23:12 List Accumulate, simple
25:09 Using the function
26:07 Adding Text Replace
27:12 List Accumulate, using List Zip to match pairs
29:57 Using a list of records instead
32:12 List of lists vs list of records
32:31 Skip List Zip
Негізгі бет 66 - Playing with lists in Power Query
No video
Пікірлер