From the course: Excel Business Intelligence: Power Query
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Add index and conditional columns with Power Query - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Power Query
Add index and conditional columns with Power Query
- [Instructor] All right, going to show you two more types of column calculations in Power Query. The first is super simple. It's called an index column. So in the Add Column menu, you'll see it right here. Index column, all it does is it creates a list of sequential values that you can use to identify each unique row in a table. And you can determine whether you want that to start with a zero or a one. These are often used to create unique ids that can be used to form relationships between tables. So we've been hinting at that quite a bit. Trust me, we're going to talk a lot about it in the Data Modeling 101 section and these should look pretty familiar. We had id columns that were formatted just like this for each of the look-up tables that we've already loaded. So the customer look-up, the store look-up, the product look-up. And an index column calculation or tool is another way to create those just from scratch. The second tool I want to show you is an interesting one. It's a…
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)
Power Query introduction27s
-
(Locked)
Meet Power Query aka Get & Transform2m 40s
-
(Locked)
The Query Editor3m 17s
-
(Locked)
Options for loading data in Excel1m 40s
-
Basic Power Query table transformations8m 6s
-
(Locked)
Text-specific query editing tools10m 17s
-
(Locked)
Number-specific query editing tools7m 41s
-
(Locked)
Date-specific query editing tools7m 39s
-
(Locked)
Create a rolling calendar with Power Query5m 2s
-
(Locked)
Add index and conditional columns with Power Query7m 44s
-
(Locked)
Group and aggregate data with Power Query7m 10s
-
(Locked)
Modify Excel workbook queries4m 18s
-
(Locked)
Merge queries7m 43s
-
(Locked)
Append queries5m 49s
-
(Locked)
Connect Excel to a folder of files9m 32s
-
(Locked)
Excel Power Query best practices2m 42s
-
(Locked)
Pivot and unpivot data with Power Query8m 52s
-
(Locked)
-