What is the DAX CALCULATE Function and how does it work? | ​Wyn Hopkins

Please note: this session was rescheduled for March 8th.
Thank you.
----------------------------------
Writing DAX is easy, writing the correct formula is hard. Understanding the concepts of how DAX works differently from Excel is one of the biggest hurdles to Power Pivot and Power BI adoption by the Excel crowd.

Having learned DAX initially from Rob Collie's book - "Power Pivot and Power BI" it took me a while to realize that the CALCULATE function is not a superior SUMIFS, and thinking of it that way hindered my understanding of more complicated DAX functions.

This session will cover how I explain that DAX works to people, especially Excel users.

---------------------

About the Speaker: Wyn Hopkins​

Wyn Hopkins is a Microsoft MVP, trainer, consultant, and author of the book “Power BI for the Excel Analyst”

Based in Perth, Western Australia, Wyn is the director of the Power BI and Excel consulting firm “Access Analytic”. Their YouTube channel has 40,000+ subscribers and he co-runs the Perth Power BI and Modern Excel meetup group. A long time ago he was a chartered Accountant with PriceWaterhouseCoopers but Wyn and team now spend their time delivering Power BI and Excel training along with reporting solutions for clients of all industries and sizes.
--------------
Find more about Wyn's work and connect with him:

Social Media and other links: https://wyn.bio.link/
Book and Website: https://pbi.guide/
Company https://accessanalytic.com.au/

---------------------
AGENDA: (Eastern Time)

5:30 PM - 5:40 PM- Introduction
5:40 PM - 6:40 PM - "What is the DAX CALCULATE Function and how does it work?" by ​Wyn Hopkins
6:40 PM - 7:00 PM - Q&A + Closing by Celia Alves and MS Excel Toronto Team

We are looking forward to meeting you there!