All storiesPower BI
DAX Time Intelligence: YTD, MTD, and Custom Periods
Build powerful time-based calculations in Power BI using DAX time intelligence functions.
Abhishek Raj
October 22, 202410 min read
Why Time Intelligence Matters
Every business dashboard needs time-based comparisons. DAX provides built-in functions that make this straightforward.
Essential Measures
Sales YTD =
TOTALYTD(
SUM(Sales[Amount]),
'Date'[Date]
)
Sales YoY Growth =
DIVIDE(
[Sales YTD] - [Sales YTD PY],
[Sales YTD PY]
)
Best Practices
Always use a proper date dimension table with contiguous dates and mark it as a date table in Power BI.
More to read
Recommended stories
More from Power BI and related topics.
Abhishek RajJune 27, 2026
How to Build a Power BI Dashboard from SQL Server (Step-by-Step for Beginners)
A beginner-friendly walkthrough: connect SQL Server to Power BI, model your data, create KPIs, and publish a dashboard your manager will actually use.
Power BI12 min read
Abhishek RajJune 24, 2026
How to Choose the Right KPIs for Sales, Inventory & Finance Dashboards
Stop building dashboards nobody uses. Learn how to pick KPIs for sales, inventory, and finance teams — with simple definitions and examples.
Power BI10 min read
Abhishek RajJune 23, 2026
5 MIS KPI Dashboard Best Practices for Business Teams
Learn how to design MIS dashboards that executives actually use — from KPI selection to refresh automation in Power BI and Excel.
Power BI6 min read