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 but, as soon as the customer requests for time intelligence comparing data from different tables, or to manage non-standard calendars, the DAX formulas start to be harder to write.
In this session, we are going to show how to compute classical time intelligence with the built-in Power BI tools and DAX functions. Then, we will show some more complex time intelligence formulas, which require thinking out of the box, using advanced data modeling and querying techniques to produce interesting and useful formulas.