
CALCULATE - Explaining DAX to Excel folks (IN PERSON ONLY EVENT!! )
Delete the event
Someone else is editing this event
An event can only be edited by one person at a time.
Someone else deleted this event
Someone else is editing this event
An event can only be edited by one person at a time. Try again later.
The event has been deleted and your message has been sent.
The event has been deleted and an automated message has been sent.
Writing DAX is easy, writing the correct formula is hard. Understanding the concepts of how DAX works differently to Excel is one of the biggest hurdles to Power BI adoption by the Excel crowd.
Having learned DAX initially from Rob Collie's awesome (but now a little outdated) book - "Power Pivot and Power BI" it took me a while to realise 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 to people how DAX works.
Speaker profile:
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 48,000+ subscribers and Wyn co-hosts the Perth Power BI and Modern Excel meetup group.
Once upon a time Wyn 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.
NEW VENUE!!!
Microsoft Office
Level 10
100 St Georges Terrace
Agenda: Wednesday 15th Feb 5:10pm Perth Time
• 5:10pm - Welcome (doors open 5.00 )
• 5:15pm - Power BI and Excel News
• 5:25pm - Main Session
• 6:15pm - Close (a beer afterwards? )
Hope to see you there! Please cancel your spot if you cannot make it
The session will not be recorded nor streamed on-line. This is an in-person only event.
Sign up for this event to participate in the discussion.
No post to display.

There aren’t any resources yet
Check back another time to see if any resources have been added.Loading ...

Sign up with your Fabric account
You can use the same account you use to log into the product. If you don’t have a Fabric account, you can create a Community account.
Host
3 registered
Events you might like
DATA DEVELOPMENT, DATA DEVELOPMENT, DATA FACTORY, DATABASES, FABRIC, POWER BI, REAL-TIME INTELLIGENCE
A common challenge that many companies face is not knowing all the Power BI data reports that are available and how to access/request access. The solution to this problem is a Power BI Directory, a comprehensive tool designed to help users navigate and utilize PowerBI effectively. This app is available to all users within our network and provides information on data availability, user permissions, analytics support, as well as access guides and resources to enhance the user's PowerBI skills. The app also features information specifically for Power BI developers to help drive Power BI improvements throughout the network.The Power BI Directory was put in place 4 years ago and continues to be one of the most utilized Power BI Apps in our network. During this session, we’ll discuss the design of the Power BI Directory and how this single solution has solved many problems.
Miranda Grant
DATA ENGINEERING, DATA FACTORY, DATA SCIENCE, DATA WAREHOUSE, FABRIC PLATFORM, FABRIC, POWER BI, REAL-TIME INTELLIGENCE
Join us for the third installment of our "Copilot for Fabric" series, where we explore the integration of Copilot in Microsoft Fabric using the PowerBI experience. This session is perfect for data professionals, engineers, and enthusiasts eager to leverage AI-powered assistance to enhance their data workflows.In this session, you will:Discover how Copilot can streamline your development execution in Microsoft Fabric.Watch live demonstrations showcasing Copilot's capabilities in real-world scenarios.Engage in a Q&A session to get your specific questions answered and network with fellow attendees.Whether you're new to Microsoft Fabric or looking to optimize your data workflows with AI assistance, this event will provide valuable insights and practical knowledge to help you succeed.
Jason Richards
DATA ENGINEERING, DATA FACTORY, DATA SCIENCE, DATA WAREHOUSE, FABRIC PLATFORM, FABRIC, POWER BI
In this presentation, we will cover key features and concepts I have learned over the years, offering valuable guidance for those just starting their Power BI journey. I will briefly explain these concepts and features with some demonstrations.
Doug Dean
FABRIC, POWER BI
Power BI & Fabric Certification: Tips, Tricks & Success StrategiesEarning a Microsoft certification in Power BI and Fabric validates your expertise in data analytics, visualization, and cloud-based data solutions. This session will guide you through the certification pathways, key exam topics, learning & practice resources, and best strategies to prepare effectively. We will also be covering what to expect on the day of your exam, whether online or in person at a test center, for those who are new to certifications.Join us to accelerate your career, boost your credibility, and confidently take the next step toward becoming Microsoft certified in Power BI and Fabric.Speaker: Cecilia BrusatoriPrincipal Data Consultant & TrainerHelping organizations achieve a data-driven culture by implementing Data Analytics and Business Intelligence Solutions and increasing the solution adoption via workshops, training and Centers of Excellence.Founder and Principal Data Consultant Magna Data inc, a Microsoft Partner Tech Company based in Miami, Florida, US. IT & Data-Driven Solutions ProviderTech Leader | Entrepreneur | Public Speaker | Trainer | Principal Data ConsultantShe is an experienced Data Analytics Consultant and Trainer. Microsoft Certified Professional in SQL Server, Azure, Power BI & Excel. MCSA BI Reporting. MCP Data Scientist & Data Analyst, MCP Fabric. Microsoft Certified Trainer (MCT). AWS Cloud, Snowflake DW, Databricks Fundamentals Certs.Organizer & Leader of Tech Events in the Miami/Fort Lauderdale, Florida Community.Direct Registration link: https://events.teams.microsoft.com/event/e279e7a8-1f6a-4cb9-acfe-918008d5bab1@23d9cb6d-3284-4dd7-98e5-4f6044d79de5
Cecilia Brusatori