DAX hub
DAX guides and measure patterns
DAX is small in surface area and deep in behaviour. Almost every confusing result comes back to filter context, so that is where these guides start.
DAX guides
The one idea to internalise
A measure is evaluated inside a filter context created by the visual, the slicers and any CALCULATE modifiers. The same measure returns different numbers in different places, and that is correct behaviour rather than a bug.
Free tools for this topic
DAX Formula Generator
Describe the measure you need and get valid DAX for Power BI, with the filter context explained so you know why it works.
Power BI Formula Generator
One place for Power BI calculations: describe the result you want and get DAX or Power Query M, with a note on which layer it belongs in.
Frequently asked questions
Is DAX like Excel formulas?
The syntax looks familiar, but DAX operates on tables and columns inside a filter context rather than on cells, which changes how you reason about results.
Analyze your data with AI
Open the GridMind workspace, bring in a CSV, Excel file or your Power BI model, and let AI build the formulas, charts and dashboards for you.