This video is available to SQLBI+ subscribers only.
This content is exclusive to SQLBI+ subscribers
Introducing Time Intelligence DAX functions
DAX provides a set of functions (Time Intelligence) to compute aggregations and comparisons over a range of dates: Year-To-Date, Same-Period-Last-Year, Moving Average, and so on.
The DAX time intelligence functions can work well with a month granularity, but they have limitations when you go at the day level or when you manage weeks.
This session shows how to use the standard DAX time intelligence functions with and without a Date table in your data model.
To get more details about the limitations of these functions, the alternatives, and the best practices to get a proper date table in your model, check the session Understanding Time Intelligence with DAX, which focuses on those topics.