From the course: Excel Power Tools for FP&A: Power Query and PowerPivot
Join today to access over 24,700 courses taught by industry experts.
DAX measures
From the course: Excel Power Tools for FP&A: Power Query and PowerPivot
DAX measures
- [Instructor] What if we want to create standardized formulas, just one time, name them, and then have them apply to our data everywhere, not just a cell, not just a single column. Is that possible? Well, with Dax Measures in Power Pivot, the answer is yes. Measures offer consistency, no broken formulas across worksheets. They offer scalability. They can work on thousands or millions of rows of data, and they offer flexibility. They work across different filters, time periods, departments and more. In a prior lesson, I introduce you to calculated columns, which create new fields inside of your data, one result per row. But measures are a little bit different. Measures summarize or calculate results based upon context. They only show up when you use them in a visual or a pivot table through Power Pivot. If you've ever used calculations of some or count or average in a Pivot table, you've used something like a measure, but the problem with classic Pivot tables without Power Query and…
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.