66 - Playing with lists in Power Query
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
Watch video 66 - Playing with lists in Power Query online without registration, duration hours minute second in high quality. This video was added by user WesleySon 14 April 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 116 once and liked it 5 people.