DAX with AskBI

Learn DAX by asking AskBI — from EVALUATE to CALCULATE, time intelligence and ranking, on a real model.

A hands-on DAX course taught inside the AskBI DAX editor against a real construction-industry model (Ironwood Builders). Each lesson asks a business question in plain English, lets the AI copilot write the DAX, runs it live, and explains why it works. You will go from basic EVALUATE queries through CALCULATE and filter context, iterators and variables, time intelligence, and ranking — then tie it together with the AskBI ask-refine-run workflow.

DAX query basics

○ EVALUATE a table Text
○ Group a measure by a dimension Text
○ Measure vs inline expression Text

CALCULATE and filter context

○ CALCULATE changes filter context Text
○ CALCULATE + FILTER (over-budget count) Text
○ DIVIDE and safe ratios Text

Iterators and variables

○ SUM vs SUMX Text
○ VAR for readable measures Text
○ AVERAGEX Text

Time intelligence

○ Year-over-year with SAMEPERIODLASTYEAR Text
○ Year-to-date with TOTALYTD Text
○ Month-over-month growth Text

Ranking and top-N

○ RANKX (manager margin leaderboard) Text
○ TOPN (worst projects, cost drivers) Text

The AskBI workflow

○ Ask, refine, run Text
○ Capstone: what is eroding margin? Text