Marco Russo presents Time Intelligence in Power BI

Every Power BI model has dates and the need of calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and DAX functions can help, but how do you manage holidays, working days, weeks based fiscal calendars and any non-standard calculation.

This session provides you the best practices to correctly shape a data model and to implement time intelligence calculations using both built-in DAX functions and custom DAX calculation for more complex and non-standard requirements.

Our guest speaker, Marco Russo, is a business intelligence consultant and mentor. He wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on www.sqlbi.com. Marco is a Microsoft MVP. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide.