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.
Marco Russo