DAX with AI: Scenarios – Video Course

 IMPORTANT
This course will be released by November 30, 2026.
We suggest you wait until then to purchase it, unless you want to take advantage of the bundle offer.

This course shows how to manage AI agents with complex scenarios, where your work is mainly to control the direction of the development, which includes writing DAX code and modifying the model so that it generates the correct result for the business problem described.

The course is a library of nine complete scenarios. Each one starts from the business requirement and ends with a model and a set of measures you must review and validate. A separate track of shorter lessons covers the concepts that come back in more than one scenario (grain, additivity, virtual tables, lineage, and others). Every scenario lists the lessons it requires, so you can take only the ones you need for the use case you are interested in, or you can just go through the whole course from A to Z.

Collapse allCurriculum

  • Presentation of DAX with AI: Scenarios

    • Preview of DAX with AI: Scenarios
      FREE
  • Concept: Calculation Contracts

    • Calculation Contracts and Strength of Claims
      FREE
    • Demo and Prompts
    • What is an average sale?
      FREE
    • Agree on a short contract
      FREE
    • Check and document the answer
      FREE
  • Inventory Availability from Movements, Sparse Snapshots, and Reservations

    • Inventory Availability from Movements, Sparse Snapshots, and Reservations
      FREE
    • Demo and Prompts
    • Introduction and prerequisites
      FREE
    • Introduce the model and define the on-hand contract
      FREE
    • Expose the sparse-snapshot failure
    • Reconstruct end-of-day on hand
    • Searching for a better algorithm
    • Reconstruct end-of-day reservations
    • Calculate availability and daily behavior
    • Retain source checks as a reusable test
    • Recap the module
  • Common concepts (available by Nov. 30, 2026)

    • Grain, Iteration Grain, Additivity, and Totals
    • Populations, Denominators, and Validation
    • Filter Paths and Relationship Semantics
    • Time, Events, States, and Snapshots
    • Reusable DAX: Measures, Functions, and Calculation Groups
    • Virtual Tables, Lineage, and Set-Based DAX
  • Scenarios (available by Nov. 30, 2026)

    • Currency Conversion with Historical and Current Rates
    • Comparable-Store Sales
    • Yearly Product Status Transitions
    • Support Ticket Resolution and Interaction Journeys
    • Budget, Forecast, and Actuals at Incompatible Grains
    • Shared-Cost Allocation and Profitability
    • Financial Statements with Ragged Accounts
    • Workforce Analytics