This video is available to SQLBI+ subscribers only.
This content is exclusive to SQLBI+ subscribers

Understanding Time Intelligence with DAX

Every Power BI model has dates and the need for calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on.
Quick measures and standard time intelligence functions in DAX can help, but how do you manage holidays, working days, weeks-based fiscal calendars, and non-standard calculations?
This session provides the best practices to correctly shape a data model and implement time intelligence calculations using built-in DAX functions and custom DAX calculations for more complex and non-standard requirements.
You will get deeper insights into how the standard DAX time intelligence functions work to evaluate better when you can or cannot use them, depending on your requirements.
For a more introduction session about standard time intelligence calculations in DAX, check the Introducing Time Intelligence DAX functions session.


This resource is available to SQLBI+ subscribers only. Subscribe or Login