Practical Applications of DAX
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Running Totals
Running Totals
Running Totals let you track the growth pattern of a field over time. In this lesson, we will see how to create a running total using DAX.
Calculating Market Share
Calculating Market Share
Often in business, you want to see what regions, products or sales people are generating the most revenue. Learn how to track this market share over time in this lesson.
Developing Moving Averages
Developing Moving Averages
When you have data that fluctuates in a noisy way, it can be difficult to identify the underlying trend. Moving averages are commonly used to smooth out data, and let you view the long-term trends.
Making Comparisons Over Time
Making Comparisons Over Time
Visualizing data over time is useful, but sometimes you'll prefer to see numbers. In this lesson, we'll learn how to find the difference in revenue between different time periods.
Customizing Time Offsets
Customizing Time Offsets
In this lesson, we will see how to make measures more responsive to the user's inputs, by creating a slicer that allows the user to customize the time offset for our measures from the previous lesson.
Running Totals with Varied Starting Points
Running Totals with Varied Starting Points
Creating a running total chart can be difficult if each line starts at a different point in time. In this lesson, we create a running total that shows revenue for each sales person since the date of their first transaction
Rankings over Time
Rankings over Time
In previous courses, we have created ranks of a single field at a time. Here, we will create a rank of salespeople for every month in the year, with a single measure.
Visualizing and Manipulating Averages
Visualizing and Manipulating Averages
When evaluating performance, we often want to compare individuals to an average. In this lesson, we will create a chart of revenue by sales people and use DAX to create a dynamic average line.
Comparing Sales to Averages
Comparing Sales to Averages
In this lesson, we will create a measure calculating by how much each sales person is above or below the average revenue and create a chart that can be used to evaluate performance at a glance.
Comparing Sales by Region
Comparing Sales by Region
In this lesson, we will look at creating multiple charts in Power Pivot. With simple measures, we will create charts for each region that provide a quick overview of sales trends.
