Time Intelligence
Last updated
What is Time Intelligence?
Time intelligence functions in DAX, such as DATEADD, SAMEPERIODLASTYEAR, and TOTALYTD, handle calculations that compare or accumulate values across time periods. They rely on having a proper date table marked as such in the model, with a continuous range of dates. These functions are behind common report needs like year-over-year growth or year-to-date totals.
Free resources to learn Time Intelligence
- Official docsTime intelligence functions in DAX
- ArticleTime Intelligence Functions
- VideoPower BI DAX Time Intelligence
More in stage 11: Context & Filtering
Time Intelligence: common questions
Can I learn Time Intelligence in Hindi?
This lesson is written in English. Once you sign in, open it in the interactive course and ask the AI tutor to explain Time Intelligence in Hindi or Hinglish. The tutor answers from this lesson’s own text, so it stays on the syllabus, and it runs on your own Google, OpenAI or Anthropic key.
Is this Time Intelligence tutorial for beginners?
It is lesson 64 of 131 in the free Power BI roadmap, in stage 11, Context & Filtering. If you are new to Power BI, start from stage 1 and come back here in order; if you already know the earlier stages, this lesson stands on its own.