Power Pivot

Product

Power Pivot provides advanced data modeling in Microsoft Excel, letting users relate multiple tables in a data model and write calculations in DAX; it was introduced in 2010 and later became one of the building blocks of Power BI.

Title graphic: Power Pivot (Product)

Type	Product

Key points about Power Pivot

DAX is the formula language used in Power BI, Excel Power Pivot and SQL Server Analysis Services. · Data Analysis Expressions (DAX) - Simply…

Episodes about Power Pivot

Data Analysis Expressions (DAX) - Simply Explained

2026-07-13 · Video on YouTube

Data Analysis Expressions, better known as DAX, is the calculation language that powers Microsoft Power BI, Excel Power Pivot, and SQL Server Analysis Services. In this episode of the M365 FM Podcast, Mirko Peters explains DAX in plain English and shows why…

Articles about Power Pivot (1)

Demystifying DAX: A Beginner's Guide to Data Analysis Expressions
2026-08-27 · Mirko Peters
Welcome to the ultimate beginner's guide to Data Analysis Expressions, commonly known as DAX. If you have ever stared at a raw dataset in Power BI or Excel and wond…

Frequently asked questions

What is DAX in Power BI?

DAX, or Data Analysis Expressions, is a formula language for data analysis used in Power BI, Excel Power Pivot and SQL Server Analysis Services to create custom calculations. · From the episode: Data Analysis Expressions (DAX) - Simply…

Glossary

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.

Sources

Profile: support.microsoft.com/en-gb/office/power-pivot-help-241aac41-92e3-4e46-ae58-2f2cd7dbcf4f
Feed for this topic (RSS): entity/power-pivot/feed.xml
M365.FM episodes on this topic: 1
Articles on this topic: 1

Maintained by Mirko Peters (Microsoft MVP) · Last updated: 2026-11-03