What You Need to Know Before
You Start

Starts 3 July 2025 00:40

Ends 3 July 2025

00 Days
00 Hours
00 Minutes
00 Seconds
course image

DAX in Practice: Measures, Aggregation, and Context Translation

Unlock the full potential of Power BI by mastering DAX formulas in our comprehensive course. Dive deep into advanced measures and aggregation functions, and learn to manage context effectively for developing powerful data calculations. Elevate your analytical skills with expert guidance from Pluralsight and transform the way you approach data.
via Pluralsight

659 Courses


56 minutes

Optional upgrade avallable

Not Specified

Progress at your own speed

Free Trial Available

Optional upgrade avallable

Overview

DAX (Data Analysis Expressions) is a powerful formula language in Power BI, used to create custom calculations and optimize data analysis. In this course, DAX in Practice:

Measures, Aggregation, and Context Translation, you’ll gain the ability to build advanced DAX measures in Power BI.

First, you’ll explore how to use aggregation functions like SUM, COUNTROWS, and SUMX to create effective measures and perform calculations. Next, you’ll discover how to apply conditional logic with SWITCH, AND, OR, and other logical operators to create group bands and implement business rules.

Finally, you’ll learn to manage filter and row contexts, using CALCULATE and iterator functions, as well as time intelligence functions like TOTALYTD and DATESINPERIOD for controlling evaluation contexts. By the end of this course, you’ll have the skills and knowledge of Power BI’s DAX needed to enhance your data analysis and tackle complex data scenarios efficiently.

Syllabus

  • Creating Measures with Aggregation Functions
  • Implementing Conditional Logic in Measures
  • Understanding Filter and Row Context

Taught by

Neeraj Kumar


Subjects

Business