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. Speaker: Alberto Ferrari https://SQLbits.com/speakers/Alberto_... Speaker Blog: https://www.sqlbi.com Speaker BIO: Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence. http://SQLbits.com/Sessions/Time_Inte... Tags: Azure,Power BI,Developing,Optimising,On Premises,Data Visualisation & Modelling