Power BI – Analytics with DAX (2026)

In this Bigger Brains course, you’ll learn how Data Analysis Expressions (DAX) can transform the way you model and analyze data in Power BI. You’ll explore the purpose of DAX and how to use basic arithmetic and logical operators to build meaningful calculations. You’ll see how to summarize data with calculated functions, understand the differences between calculated columns and measures, and apply logic using functions like IF and SWITCH to segment and evaluate your data more effectively.

You’ll also learn how to use the powerful CALCULATE function to modify filter context, remove filters, and compare results with and without those changes. You’ll explore table and scalar expressions, learn the value of summary tables, and create new tables using functions such as SUMMARIZE and GROUPBY. By the end of the course, you’ll be able to confidently apply foundational DAX techniques to enhance your data modeling and deliver clearer, more actionable insights in Power BI.

Topics covered include:

• Explain the purpose of DAX
• Use basic arithmetic operators
• Summarize data with calculated functions
• Differentiate between calculated columns and measures
• Compare data using logical operators
• Apply logic to data using the IF logical function
• Segment data into groups using the SWITCH function
• Explain the role of the CALCULATE function in modifying filter context
• Use CALCULATE to remove filters
• Define what a table expression is in DAX and how it differs from a scalar expression
• Explain the purpose of summary tables in DAX
• Create new tables using the SUMMARIZE function
• Reshape data using the GROUPBY function