From the course: Excel: Power Pivot for Beginners
Join today to access over 24,900 courses taught by industry experts.
Enhance your data by adding calculations - Microsoft Excel Tutorial
From the course: Excel: Power Pivot for Beginners
Enhance your data by adding calculations
- [Instructor] With Power Pivot, you can quickly and easily create calculations without having to input complex formulas or write code. If you'd like to follow along with me, then have the exercise file open for this movie. Oh, and throughout this course, if you see this notification pop up, simply click on Enable Content and you're good to go. With Power Pivot selected, go ahead and click on Manage to enter the data model. And let's go ahead and maximize the screen. Okay. With the Building Permits table selected, say that we want to include Work Group in this table. If you have a look at the top of the screen here and scan through each of the columns, you'll notice that this particular field, that is, Work Group, doesn't appear. However, it does appear here in our second table called Work Type. To bring this field into our first table, we need to use something called a DAX formula. This is a particular syntax that's unique to Power Pivot. So in the first row, beneath Add column…
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.