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.
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, 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…
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…
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.