Every Power BI model has dates and the need of calculation over dates to aggregate and compare data, like YearToDate, SamePeriodLastYear, 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 nonstandard calculation?
This session provides you the best practices to correctly shape a data model and to implement time intelligence calculations using both builtin DAX functions and custom DAX calculation for more complex and nonstandard 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