Time intelligence and date tables in Power BI & Excel - Marco Russo

• What we'll do
Session by Marco Russo, MVP, Author, DAX Guru

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.

• What to bring

• Important to know
We will provide only soft drinks as we do not have any sponsors. Please RSVP as space is limited.