From the course: Excel: Working Together with Power Query and Power Pivot
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create lookups as new fields
From the course: Excel: Working Together with Power Query and Power Pivot
Create lookups as new fields
- [Instructor] Now that we've created a link between two data sources in PowerPivot, wouldn't it be wonderful to see this all come together in one view, one table? Luckily this is incredibly easy using a feature in PowerPivot called custom calculations, or DAX, D-A-X, which stands for data analysis expressions. Now DAX can be used for doing all sorts of fancy things with your data, such as creating new calculations, new views, and that kind of thing, and all this without having to write complex formulas. I suggest you have the Excel file open for this video to follow along with me, and from the PowerPivot menu, go ahead and select manage. This opens up the data model. Once open, what you'll see is we have two tabs, one for the data source called EV sales, which is our raw data, and another called location type. Now, if we go ahead and select diagram view, you'll see that we've actually created a relationship that's…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.