Skip to main content
DAX in Power Pivot

Practical Applications of DAX

You know have a comprehensive understanding of how DAX works. Here, you’ll explore how to apply its functions to real world business problems. In this course, you’ll explore a case study and one company’s use of DAX.

Advanced        10 Lessons        150 Minutes        CPD Credits
Start Today

About This Course

You’ll see DAX in action in this course, as you explore a practical example of creating a rank of salespeople for every month in the year, with a single measure.

Across 10 lessons, you’ll learn how to calculate running totals, market share, comparisons and rankings in DAX.

By the end of the course, you will understand not just the concept of how DAX works, but also how it can be applied to suit your project.

Start Today

Learning Outcomes

  • Calculate running totals using DAX
  • Calculate the market share of different products
  • Develop moving averages
  • Make comparisons over time
  • Develop rankings over time
  • Compare sales figures between regions


1. Running Totals
2. Calculating Market Share
3. Developing Moving Averages
4. Making Comparisons Over Time
5. Customizing Time Offsets
6. Running Totals with Varied Starting Points

Read More

7. Rankings over Time
8. Visualizing and Manipulating Averages
9. Comparing Sales to Averages
10. Comparing Sales by Region
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world