Start here
Lessons and reference
Look things up
Start here
SQL
Power Query
Data modeling
Power BI and DAX
Finance playbooks
Run queries
Build and check
Every function you need to build reports, written for the work accountants and finance teams do: sales and margin, receivables and aging, budgets and variances, period ends. Each page gives the syntax, a plain-English explanation, an example on real sample data and the mistakes to avoid.
Measures and calculated tables for Power BI, Excel Power Pivot and Analysis Services.
Browse DAX functions → 226functionsThe formula language behind Power Query in Excel, Power BI and Fabric: shape and clean data before it loads.
Browse Power Query M functions →New to these? Start with DAX fundamentals or M basics, then come back here to look things up. The same pages are plain Markdown for AI tools: add /md to any function address, or read llms.txt.