Toronto PASS


Next Meeting




Toronto SQL Server & Data Platform w/Marco Russo DAX & Power BI

It's time to get back to talking about SQL Server and Data Platform

Our first meeting of the season as a special location since we couldn't book our usual room.  The good news is it's conveniently located in the TD Tower, so lots of subway options to get you there. We will have limited space here, so get your RSVP in ASAP. 

The second great news is that we have a fantastic presenter scheduled.

You must be registered (RSVP here) to participate in the pizza and prize draws.

Introduction to DAX in Power BI

DAX is the language to enrich the data models in Power BI. You can create measures, calculated columns, and calculated tables. In this sessions, you will learn the difference between them, and the syntax you use in DAX to create simple formulas for common scenario, such as: 

• Analysis by range of prices (1-10, 11-20, 21-30, …) 

• How to pass a calculation parameter using a slicer

• Year-over-year calculation 

• Comparison between budget and sales at different granularities

As you will see, you can use measures to overcome certain (apparent) limitations of Power BI, creating richer reports over your data.

Marco Russo 
Business Intelligence consultant, SQLBI 

Marco Russo is a consultant and trainer in Business Intelligence. He is a founder of SQLBI (, which provides mentoring and consulting on Business Intelligence based on Microsoft technologies. Marco has several Microsoft certifications including SSAS Maestro, MCDBA, MCSD, MCSA and MCAD, and is also an MVP and a former MCT. He wrote several books about Analysis Services, Power Pivot, Power BI, and DAX, for Microsoft Press. He is also a speaker at international conferences such as Microsoft Ignite, PASS Summit, and SQLBits. 


5:30 - 6:00 PM Pizza and Networking

6:00 - 6:15 PM Updates and Announcements

6:15 - 8:15 PM Presentation(s)

8:15 - 8:30 PM Wrap-up and prize draw

Featured Presentation:

DAX & Power BI with Marco Russo

Marco Russo, Consultant SQLBI

See registration website for more info.

About Marco:
Marco is a Business Intelligence consultant and mentor. He wrote several books about Power BI, Analysis Service, and Power Pivot. He also regularly writes articles and white papers that are available on Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and SQLBits. He also enjoys delivering evening sessions at local user groups during his trips.

Back to Top