Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Use DAX in semantic models

Microsoft via Microsoft Learn

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
  • 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.

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

Reviews

Start your review of Use DAX in semantic models

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.