DAX 101

Session Overview:
Are you new to DAX (Data Analysis Expressions) in Power BI and Excel? This beginner-friendly session is designed to help you get started with DAX and unlock the full potential of your data. Whether you’re working on Power BI dashboards, reports, or Excel models, understanding DAX is essential to move beyond simple drag-and-drop functionality.
In this session, we’ll cover the core concepts of DAX, including key functions, the importance of context and filtering, and how to start building powerful formulas that will elevate your reports and dashboards. By the end of this session, you’ll be confident in writing basic DAX expressions to create measures and calculated columns, making your data analysis more insightful and impactful.
Additionally, we will introduce DAX Studio, an external tool that helps you write, test, and format DAX expressions. You’ll learn how to use DAX Studio to validate your formulas, debug results, and optimize performance—skills that will significantly enhance your Power BI development.
No prior knowledge of DAX is required, so come prepared to take your data analysis skills to the next level. This session is perfect for anyone eager to go beyond the basics and harness the full power of DAX in Power BI and Excel.
Learning Objectives:
- How to write DAX in Power BI or Excel
- Learning the basics of DAX (Data Analysis eXpressions) language
- Easier to understand DAX and using it in Power BI or Excel.
Speaker: Damodaran (Damu) Venkatesan
Recorded at: Community Summit NA 2025
Type: Breakout Session
Ability Level: 101 – New To
Primary Product: Power Platform
Tracks: Business Intelligence (BI) & Reporting
Terms: All rights reserved by the speaker, Community Summit NA, and Dynamic Communities and cannot be reproduced or distributed without express written consent by the speaker and Dynamic Communities.