Functions covered in the reference docs
Don't just read the example — try it yourself
Edit the numbers in a real, live example — right on the page, no Excel required — and watch the result recalculate instantly. 75 function pages have one so far, across DAX and Power Query M.
Completely free, unlimited — it's just math running in your browser, not an API call.
Try it live
| Field | Value |
|---|---|
| Numerator | |
| Denominator | |
| Alternate result (optional) |
See exactly how a formula finds its answer
A color-coded diagram walks each argument straight from the formula to the exact piece of data it touches — numbered badges tying search values to matched rows, branches to their results, keys to the relationships they define. No more guessing which argument did what, or where a result came from. 10 of these are live today, across DAX functions and modeling concepts.
Anatomy of LOOKUPVALUE()
| ProductKey | ProductName | Category |
|---|---|---|
| 10012 | Trail Runner Tire | Bikes3 |
| 1002 | Commuter Helmet | Accessories |
| 1003 | All-Terrain Tire | Bikes |
| 1004 | Bike Lock | Accessories |
Search Value
11001
Result
✓Bikes
Search Value — the value to find: 1001.
Search Column — LOOKUPVALUE() scans ProductKey and finds the match in row 1.
Result Column — it takes the value from Category in that same row.
Result — the measure returns "Bikes". With no match, it would return BLANK() instead (or the optional default value, if one is supplied).
DAX
Learn measures, functions, filter context, and advanced calculations.
Power Query
Master data transformation using M language and query techniques.
Data Modeling
Build efficient star schemas, relationships, and semantic models.
Microsoft Fabric
Explore Lakehouse, Warehouse, pipelines, and modern analytics.
Visuals
Design effective charts, tables, slicers, and custom formatting.
Power BI Service
Manage workspaces, dashboards, scheduled refresh, and security.
DAX Patterns
Ready-made patterns for totals, ranking, and running calculations.
AI-Assisted Power BI
Use AI to accelerate DAX, Power Query, modeling, and report development.
Governance
Reference sheets for RLS matrices, gateway architecture, and report themes.
From the Blog & Tutorials
Real fixes, cheat sheets, and full builds — not just reference pages.
Power BI Desktop Keyboard Shortcuts Cheat Sheet
A fast, scannable reference for the Power BI Desktop shortcuts worth memorizing — DAX formula bar editing, report canvas selection, and table navigation.
Power BI Error: Visual Has Exceeded the Available Resources
"Visual has exceeded the available resources" means a visual's query hit a hard time or memory cap in Power BI Service (and now Desktop too). Here's why the limit exists, and the fixes that actually hold up once the report is published.
This site talks to AI agents directly.
Every doc page is also available as a plain-text index, purpose-built for LLMs and coding assistants to read directly instead of scraping rendered HTML — llms.txt is an emerging convention several sites (including this one) already support.
$ curl https://pbidocs.com/llms.txt # Docs - Getting Started - [Getting Started] (/docs/getting-started): Start here to install Power BI Desktop and learn the basics. - AI-Assisted Power BI - [DAX with AI] (/docs/ai-power-bi/dax-with-ai): Use AI to write, explain, and debug DAX calculations faster. ...
Stay in the loop
New Power BI content, sent occasionally. No spam.
Just your email, nothing else. Privacy policy