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
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.
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
Lessons
1. Calculating Running Totals
2. Calculating Market Share
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.
