Skip to main content
The Query Editor and DAX

Practical Applications of DAX

DAX has a wide range of useful business applications. This course takes what you have learned about Power BI’s formula language and shows you how it can be applied in a practical business context.

Advanced        9 Lessons        120 Minutes        CPD Credits
Start Today

About This Course

Now that you understand the key functions of DAX, you are ready to put them to practical use.

You will learn how to create a running total using DAX and how to deal with potential pitfalls that may arise from differing start dates. You will also learn how simple measures can be used to produce charts.

By the end of this course, you will have applied your knowledge of DAX to a practical business example. You will also have produced a compelling visualization of your data.

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. Calculating Running Totals
2. Calculating Market Share
3. Developing Rolling Averages
4. Comparing Values Over Time
5. Customizing Time Offsets
6. Normalizing Running Totals

Read More

7. Tracking Rankings Over Time
8. Comparing Sales to Averages
9. 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