? IF & SWITCH Functions in DAX

✨ Quick Overview

IF and SWITCH are decision-making functions in DAX. They help convert raw numbers into meaningful business labels such as Pass/Fail, Grade, Status, or Category.

? Key Concepts

• Both functions work row by row
• Mostly used in Calculated Columns
• IF = simple condition
• SWITCH = multiple conditions

? Syntax / Theory

// Basic IF syntax
IF(Condition,Result_if_True,Result_if_False)

// SWITCH with TRUE for range conditions
SWITCH(
TRUE(),
Condition1,Result1,
Condition2,Result2,
DefaultResult
)

? Common Path for ALL Examples

1. Open Power BI Desktop
2. Home → Enter Data → Load table
3. Go to Data View
4. Modeling → New Column
5. Write DAX formula

? Sample Data – Students

✅ Example 1: IF – Pass / Fail

Business Question: Has the student passed?
Rule: Marks ≥ 40 → Pass else Fail

// Pass or Fail decision for each student
Result =
IF(Students[Marks] >= 40,"Pass","Fail")

✅ Example 2: IF – Scholarship Eligibility

Business Question: Who gets scholarship?
Rule: Marks ≥ 80 → Eligible else Not Eligible

// Scholarship eligibility logic
Scholarship =
IF(Students[Marks] >= 80,"Eligible","Not Eligible")

✅ Example 3: SWITCH – Student Grade

// Grade assignment using SWITCH
Grade =
SWITCH(
TRUE(),
Students[Marks] >= 90,"A",
Students[Marks] >= 75,"B",
Students[Marks] >= 60,"C",
"D"
)

? Use Cases

• Pass / Fail logic
• Grades and ratings
• Status flags
• Business classifications