- Data Analysis Expressions (DAX) is a formula language for Power BI that enables you to create calculations, add logic, and enhance data analysis within your reports and semantic models.
In this module, you learn how to:
- Describe the different DAX calculation types.
- Write DAX formulas.
- Describe DAX data types.
- Work with DAX functions.
- Use DAX operators.
- Use DAX variables.
- Adding DAX calculations to Power BI semantic models allows you to define custom logic within your data model, to enable deeper analysis and data-driven business decisions.
In this module, you learn how to:
- Create calculated tables.
- Create calculated columns.
- Create measures using DAX.
- DAX time intelligence functions in Power BI enable users to analyze and compare data across different time periods, supporting insightful reporting on trends, growth, and performance over time.
By the end of this module, you'll be able to:
- Define time intelligence.
- Use common DAX time intelligence functions.
- Create useful intelligence calculations.
- Calculations in Power BI are necessary to enrich data analysis. Visual calculations simplify complex formulas, enhance performance, and reduce maintenance.
By the end of this module, you'll be able to:
- Understand visual calculations and how they differ from measures.
- Create visual calculations in Power BI Desktop.
- Use parameters in visual calculations.
Build GenAI Apps from Scratch — UCSB PaCE Certificate Program
Google, IBM & Meta Certificates — 40% Off for a Limited Time
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Syllabus
- Write DAX formulas for semantic models
- Introduction
- Understand DAX calculation types
- Write DAX formulas
- DAX data types
- Work with DAX functions
- Use DAX operators
- Use DAX variables
- Check your knowledge
- Summary
- Create DAX calculations in semantic models
- Introduction
- Create calculated tables
- Create calculated columns
- Understand implicit measures
- Create explicit measures
- Use iterator functions
- Exercise - Create DAX calculations
- Check your knowledge
- Summary
- Use DAX time intelligence functions in semantic models
- Introduction
- Use DAX time intelligence functions
- Additional time intelligence calculations
- Exercise - Use time intelligence functions
- Check your knowledge
- Summary
- Create visual calculations in Power BI Desktop
- Introduction
- Understand visual calculations
- Create visual calculations
- Use parameters in visual calculations
- Exercise - Create visual calculations in Power BI Desktop
- Module assessment
- Summary