Topic: Time Intelligence and Date Tables in Power BI & Excel
Speaker: Marco Russo (MVP, Author, DAX Guru)
Summary: 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.
RSVP at https://www.meetup.com/Atlanta-Modern-Excel-User-Group/events/250622970/
When: Wednesday, May 16, 2018
Where: Microsoft Technology Center, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA 30009 (https://binged.it/2KQLAPw)