Welcome to the Cincinnati Professional Association for SQL Server!

CincyPASS is a professional organization/user group dedicated to all aspects of SQL Server from database administration to application development and business intelligence.

Our meetings occur every month on the 3rd Tuesday, in the Microsoft office located at 4445 W Lake Forest Drive, Suite# 100, Blue Ash, OH 45242. Please ensure to register to help us plan for food. Unless noted otherwise the monthly meeting agenda will be

  • 5:30 - Networking and Food
  • 6:00 - PASS news and Announcements
  • 6:15 - Featured Presentation
  • 7:15 - Q&A Session / Door Prizes


Next Meeting: Tue, May 21 2019

Marco Russo - Time Intelligence in Power BI

Language: English
Event Type: In-Person
Online Meeting URL: None



UTC : Tue, May 21 2019 09:45 - 11:45
Event Time : Tue, May 21 2019 05:45 - 07:45 Eastern Daylight Time
Your Local Time: Tue, May 21 2019 09:45 - 11:45


4445 W Lake Forest Drive
Blue Ash, Ohio

Direction: None

Featured Presentation

Time Intelligence in Power BI

Speaker: Marco Russo, Consultant SQLBI

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. 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.

About Marco: Marco is a Business Intelligence consultant and mentor. He worked with Analysis Services since 1999, and wrote several books about Power Pivot, Power BI, Analysis Services Tabular, and the DAX language. With Alberto Ferrari, he writes the content published on, mentoring companies’ users about the new Microsoft BI technologies. Marco is also a speaker at international conferences such as Microsoft Data Insights, PASS Summit, Microsoft Ignite, and SQLBits.






Back to Top