DAX Functions in Power BI
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Write DAX in Power BI to build calculated tables, columns, and measures, then filter, count, and rank data with iterating functions.
DAX, short for Data Analysis Expressions, is the formula language Power BI uses for calculated columns, measures and custom tables. Visuals built only from fields in a model have limits, and writing your own formulas gives a report more control and flexibility. The lessons start with how row, query and filter context shape a result, then work through functions that add tables and columns, summarize values, apply filters and rank data row by row.
What You Will Achieve
- Predict how context and table relationships change the value a DAX formula returns
- Add a date table, cost columns and cleaned fields to a Power BI data model
- Write report measures that use variables to keep formulas short and efficient
- Pick the right function to filter, count or rank data, including RANKX for ordered results
Program Overview
Setting Up Data Models with DAX
Builds the data model side of DAX, writing functions that add tables and calculated columns and showing the contexts a formula runs in.
- Row, query, and filter context
- Calculated tables and a date table
- Calculated cost columns and data cleaning
- Connecting data across tables
DAX Measures and Variables
Turns to calculated measures, comparing ways to create them and using variables to make formulas shorter and more efficient.
- Ways to create DAX measures
- Advantages of explicit measures
- Variables in DAX
- Basic statistical and quick measures
Filtering, Counting, and Iterating Functions
Covers commonly used filtering and counting measures, then iterating functions that evaluate data one row at a time and rank it.
- Filter functions, including ALL
- Calculating with a filter
- Counting functions
- Iterating functions and RANKX()
Certificate Awarded (Paid)
Job Outlook
DAX skills are used wherever reports and dashboards are built in Power BI, including business intelligence and data analysis work, where calculated columns and measures produce the figures shown in visuals.
Good for: Power BI users who build reports and want to write their own calculations for tables, columns and measures.
Keep in mind: The four chapters stay with core function groups for tables, measures, filtering and iteration, so expect a working base in DAX and further study for anything beyond them.
Bottom line: An exercise-led look at commonly used DAX functions in Power BI, closing with iterating functions and RANKX rankings.
Frequently Asked Questions
What is the difference between a calculated column and a measure?
A calculated column is worked out row by row and stored in the data model. A measure is calculated when a visual needs it, using that visual's filter context. The second chapter shows when each one fits.
What are iterating functions in DAX?
They step through a table one row at a time, evaluate an expression for each row and then aggregate the results. The final chapter practices them and uses RANKX to rank data in a report.
Which filter functions does the course use?
The filtering chapter works with CALCULATE and ALL, with exercises on applying different filters and calculating a value with a filter in place, alongside the counting functions taught in the same chapter.
Does the course use quick measures?
Yes. The measures chapter compares the ways of creating a measure, including quick measures, and sets them beside explicit measures you write yourself, explaining why explicit measures have advantages.
User Reviews
Write your review
You must be logged in to post a review.
Reviews can only be posted by registered learners. Log in or create a free account, then you will return here to post.
There are no reviews yet.