Time Intelligence is probably the most interesting feature of any analytical solution. Quick measures in Power BI can help you up to a certain point, because if you have more than one date column in your data model, it is also important creating the right data model, having the right Date table, and using the right DAX function to compute calculations such as Year-To-Date, Month-To-Date, Same-Period-Last-Year, and others.

In this session, you will see how to properly use time intelligence calculations in Power BI, avoiding data modeling and DAX mistakes, and using the right work around for the missing "Mark as Date table" feature that you have in Power Pivot.

Marco Russo, Consultant and Mentor, SQLBI

Marco Russo is a Business Intelligence consultant and mentor. He has worked with Analysis Services since 1999, and written several books about Power Pivot, Power BI, Analysis Services Tabular, and the DAX language. With Alberto Ferrari, he writes the content published on www.sqlbi.com, mentoring companies' users about the new Microsoft BI technologies. Marco is also a speaker at international conferences such as Microsoft Ignite, PASS Summit, PASS BA Conference, and SQLBits.