Time Intelligence in DAX / Power BI

Time Intelligence in DAX / Power BI

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 require working days’ evaluation, complex and custom calendar shapes, seasonal pattern recognition, 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 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.

Alberto Ferrari

http://photos3.meetupstatic.com/photos/event/a/5/2/e/600_457662286.jpeg

Alberto is a Business Intelligence consultant.

His main interests reside in two areas: a methodological approach to the BI development lifecycle, and performance tuning of ETL and SQL code. His activities are related to designing and implementing solutions based on Integration Services and Analysis Services for the financial, manufacturing, and statistical areas.

He is also an author and a speaker in international conferences such as TechEd, PASS Summit, SQLRally, and SQLBits. Alberto is certified as an SSAS Maestro.