Time Intelligence is probably the most interesting feature of any analytical solution. Computing Year-To-Date, Month-To-Date, Same-Period-Last-Year, is quite easy in DAX. However, DAX formulas starts to be harder as soon as you need to include details such as holidays, working days, weeks and fiscal calendars. Moreover, you need to create the proper data model to make all the measures comparable with the same dates.
In this session, we are going to show how to compute classical time intelligence with the built-in DAX functions. Then, we will show some more complex time intelligence formulas, which require thinking out of the box, leveraging on data modeling and querying techniques to produce interesting and useful formulas.
(no tags)
The video is not available to view online.