From the course: Power BI Data Methods (2019)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Creating list objects
- Remember that we can think of a list object as a single column within a table or table object. The M language directly supports objects such as tables, lists, records, functions and parameters. Within the M language we classify lists, records, and tables as structured values or ordered sequences of values. We do not typically load lists as data but rather use them as intermediaries in developing other queries. We can create lists using functions that create original lists or that translate into list objects. As we can see here with the example functions on the screen. In our M language objects Power BI file, for the first method we can create lists manually using formulas between curly brackets. Let's create an example list with both character and number items. We select new source, select blank query, and we start by typing the formula. 2 5 A C Notice that the characters need to have quotation marks around them. We…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
(Locked)
Utilizing parameters3m 6s
-
(Locked)
Creating list objects4m 2s
-
(Locked)
Referencing a list as a column in a table3m
-
(Locked)
Leveraging record objects1m 49s
-
(Locked)
Leveraging list functions1m 57s
-
(Locked)
Creating date tables3m 3s
-
(Locked)
Looping with lists6m 34s
-
(Locked)
Combining list objects5m 36s
-
(Locked)
-
-
-