Power BI + AI Documentation Platform

Master Power BI.
Build smarter with AI.

Learn DAX, Power Query, Data Modeling, Microsoft Fabric, and AI-assisted Power BI development with clear documentation and practical examples.

Browse Documentation Get Started

AI-Powered — try it live

DAX Formula Builder

>▌

Building…

Total Sales YTD =
TOTALYTD(
    SUM(Sales[Amount]),
    'Date'[Date]
)

Describe a calculation in plain English, get back a real DAX measure or Power Query M step. Try the Formula Builder

178+

Pages

43+

DAX Pages

Topics

Interactive Examples

Stop reading examples. Try them.

Most Power BI references show you a formula and a result and leave it at that. On 59 function pages so far — DAX and Power Query M — you can edit the numbers yourself and watch the actual result recalculate, right on the page, no Excel, no upload.

Browse all 59 live examples Try DIVIDE() live

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.

Featured Tutorial

Build an FMEA (Failure Mode & Effects Analysis) Dashboard in Power BI

An end-to-end tutorial for reliability and systems engineers: turn a failure mode register into RPN scoring, before/after corrective-action tracking, and a severity-override priority rule, using the same latest-assessment DAX pattern as a risk register.

Start building

DAX Text Functions Cheat Sheet

A fast, scannable reference for the DAX text functions you'll actually reach for — substrings, case and whitespace, combining values, replacing text, and formatting numbers as strings.

DAX Error: A Function 'CALCULATE' Has Been Used in a True/False Expression

This error means CALCULATE() got nested directly inside a boolean condition instead of being used the way it's meant to — as the outer wrapper. Here's the actual rule, and the two ways people usually trip it.

View all blog posts →View all tutorials →

For AI Agents

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.

View /llms.txt View /llms-full.txt

llms.txt

$ 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

Master Power BI.Build smarter with AI.