Home / Power BI / Pragmatic Guides - DAX Logical Functions
Pragmatic Guides - DAX Logical Functions
Learn DAX logical functions with Amelia Roberts! Master AND, OR, NOT, SWITCH, TRUE, and error-handling to improve your Power BI calculations and create smarter, more dynamic reports.
Master the power of DAX logical functions with instructor Amelia Roberts in this focused course on AND, OR, NOT, SWITCH, TRUE, and error-handling functions. Whether you're refining your Power BI skills or just getting started with DAX, this course will help you understand how logical expressions drive decision-making in your data models.
Each module breaks down a key function, providing clear explanations and practical examples to enhance your data calculations. By the end of this course, you'll confidently use DAX logical functions to create smarter, more dynamic reports and improve the accuracy of your analyses.
Course Outline ( Free Preview)
Module 00 - What You Need to Get Started
Module 01 - AND
Learn how the AND function works in DAX to evaluate multiple conditions at once. Amelia Roberts will show you how to use this function to refine your calculations and ensure that all required conditions are met before returning a result.
Module 02 - IFERROR
Discover how IFERROR helps manage errors in DAX calculations. This module covers how to detect and handle potential issues in your formulas, ensuring your reports remain accurate and reliable even when unexpected values arise.
Module 03 - IF15 min.
Understand how the IF function operates within DAX expressions. Amelia Roberts will explain its role in logical evaluations and how it interacts with other functions to support complex calculations in Power BI.
Module 04 - NOT6 min.
Explore the NOT function and how it allows you to reverse logical conditions in your formulas. This module will demonstrate how to apply NOT effectively to refine filters and create more flexible calculations in your reports.
Module 05 - OR9 min.
Learn how to use the OR function to check multiple conditions in DAX. Amelia Roberts will guide you through practical examples that show how OR can expand the flexibility of your logic-based calculations.
Module 06 - SWITCH12 min.
Master the SWITCH function to simplify complex IF statements in DAX. This module covers how to use SWITCH for multiple condition evaluations, making your formulas more efficient and easier to read.
Module 07 - TRUE7 min.
Understand the TRUE function and its role in logical comparisons. Amelia Roberts will show you how it works alongside other logical functions to enhance conditional calculations in your Power BI reports.
Amelia Roberts holds a Master's Degree in Education and spent more than a decade teaching students in K-12 classrooms before bringing her passion for learning and technology to Pragmatic Works. Her background as an educator gives her a unique ability to break down complex topics, connect with learners of all skill levels, and help people feel confident adopting new technologies.
Today, Amelia specializes in Microsoft Copilot, Copilot Studio, AI adoption, and custom agent development. She works with organizations to help them move beyond the hype of AI and focus on practical ways to increase productivity, improve business processes, and solve real-world challenges. Whether she's leading an executive workshop, building a custom AI solution, or teaching a hands-on training course, Amelia is focused on helping people find meaningful ways to use technology in their everyday work.
In addition to her AI expertise, Amelia has extensive experience with Microsoft Power Platform and Power BI, helping organizations automate processes, connect systems, and turn data into actionable insights. She enjoys partnering with both business and technical teams to identify opportunities for innovation and create solutions that deliver lasting value.
Known for her energetic and engaging teaching style, Amelia believes learning should be practical, interactive, and immediately applicable. Her goal is simple: help people leave every session feeling empowered, inspired, and ready to put what they've learned into action.
Outside of work, Amelia enjoys reading, trying new foods, exploring new places, and spending time with family and friends.
