Using DAX to Build Measures in Power BI

Focused View

Hallam Webber

29:33

19 View

1. Course Introduction.mp4

01:10

2. Overview of DAX in Power BI.mp4

01:33

3. DAX Measures Demo.mp4

15:08

4. Time Intelligence Demo.mp4

06:00

5. Semi-Additive Measures Demo.mp4

03:49

6. Summary.mp4

01:53

Description

Augment your Power BI data model with custom DAX measures to improve efficiency and provide better metrics for your users. Power BI comes with an extensive range of built-in functions that assist with many common report scenarios. But sometimes, you'll need to create your own measures where the "out of the box" ones don't do exactly what you want or exhibit unintended behavior.

In addition to scenario-specific functions, Power BI has general-purpose functions that you can use in DAX statements to create complex custom measures. This lesson explores the use of specific and general functions with DAX to address several scenarios.

Learning Objectives

Learn how to replace numeric columns with measures that use SUMX and CALCULATE functions
Learn about Time Intelligence functions and how to make year-on-year and month-on-month reports using time-based functions and custom DAX measures
Learn how to use Time Intelligence functions and custom DAX to create semi-additive point-in-time measures

Intended Audience

This lesson is intended for anyone who wants to learn how to use DAX to build measures in Power BI.

Prerequisites

To get the most out of this lesson, you should have a basic understanding of Microsoft Power BI.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

DAX

Hallam Webber

Instructor's Courses

Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.

Cloud Academy

View courses Cloud Academy

Join thousands of users in achieving your personal goals through Cloud Academy. Score job-ready tech skills that you can practice in a real environment, without the risk of extra costs or making mistakes. It’s simply the smartest way to gain certifications and get career-ready.