M365Con 2027 – free online conference · 11–22 Jan 2027 · 120 sessions→ m365con.net

Date table

Concept

A date table is a dedicated calendar dimension in a Power BI semantic model with one row per date over a continuous range, used for filtering, grouping and time intelligence calculations.

✦ CONCEPTDate tableM365.FM
Title graphic: Date table (Concept)
TypeConcept
Documentationlearn.microsoft.com/en-us/power-bi/guidance/model-date-tables

Episodes about Date table

Build a Power BI Star Schema for Faster Reports

2025-11-03 · Video on YouTube

when people first open power bi, they usually jump straight into visuals. charts, slicers, maps—it feels like that’s where the real action is. but the longer you work with it, the more you realize that the real magic is happening underneath, in the way the…

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…

2025-11-03 – Build a Power BI Star Schema for Faster Reports2026-07-13 – Data Analysis Expressions (DAX) - Simply Explained2025-112026-07
Timeline of episodes about Date table

Frequently asked questions

How can I practice DAX?

Build a simple model with a date table, a sales table and a product table, then write one measure each day: total sales, prior year sales, growth percentage and a running total. · 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

Maintained by Mirko Peters (Microsoft MVP) · Last updated: