Logical functions in DAX are used to apply conditions in calculations. They help you create rules, categorize data, and build dynamic measures based on specific criteria.<\/p>\n\n\n\n
The two most commonly used logical functions in DAX are IF and SWITCH.<\/p>\n\n\n\n
The IF function checks a condition and returns one value if the condition is TRUE and another value if it is FALSE.<\/p>\n\n\n\n
IF(logical_test, value_if_true, value_if_false)<\/pre>\n\n\n\nExample 1 \u2013 Basic Condition<\/h3>\n\n\n\n
Profit Status = IF(Sales[Profit] > 0, \"Profit\", \"Loss\")<\/pre>\n\n\n\nThis calculated column checks if Profit is greater than 0.
If TRUE, it returns “Profit”; otherwise, it returns “Loss”.<\/p>\n\n\n\nExample 2 \u2013 Measure with IF<\/h3>\n\n\n\n
High Sales = IF(SUM(Sales[Amount]) > 100000, \"Target Achieved\", \"Below Target\")<\/pre>\n\n\n\nThis measure dynamically evaluates total sales based on filter context.<\/p>\n\n\n\n
When to Use IF<\/h3>\n\n\n\n
\n
- Categorizing data (Pass\/Fail, Profit\/Loss)<\/li>\n\n\n\n
- Creating performance indicators<\/li>\n\n\n\n
- Applying simple conditional logic<\/li>\n<\/ul>\n\n\n\n
SWITCH Function<\/h2>\n\n\n\n
The SWITCH function is used when you need to evaluate multiple conditions. It is cleaner and more readable than using multiple nested IF statements.<\/p>\n\n\n\n
Syntax<\/h3>\n\n\n\n
SWITCH(expression, value1, result1, value2, result2, ..., else_result)<\/pre>\n\n\n\nExample 1 \u2013 Category Mapping<\/h3>\n\n\n\n
Sales Category =
SWITCH(
TRUE(),
Sales[Amount] >= 100000, \"High\",
Sales[Amount] >= 50000, \"Medium\",
Sales[Amount] >= 10000, \"Low\",
\"Very Low\"
)<\/pre>\n\n\n\nHere, SWITCH(TRUE()) allows you to evaluate multiple logical conditions.<\/p>\n\n\n\n
Example 2 \u2013 Based on Exact Match<\/h3>\n\n\n\n
Region Name =
SWITCH(
Sales[RegionCode],
1, \"North\",
2, \"South\",
3, \"East\",
4, \"West\",
\"Unknown\"
)<\/pre>\n\n\n\nWhen to Use SWITCH<\/h3>\n\n\n\n
\n
- When handling multiple conditions<\/li>\n\n\n\n
- Replacing nested IF statements<\/li>\n\n\n\n
- Mapping codes to readable labels<\/li>\n<\/ul>\n\n\n\n
IF vs SWITCH<\/h2>\n\n\n\n
IF is best for simple two-condition logic.<\/p>\n\n\n\n
SWITCH is better for handling multiple conditions and improves readability.<\/p>\n\n\n\n
Using SWITCH makes your DAX cleaner and easier to maintain.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
Logical functions like IF and SWITCH allow you to apply decision-making logic in your data model. They are essential for categorization, KPI evaluation, and building intelligent Power BI reports.<\/p>\n\n\n\n
<\/strong><\/p> <\/div> <\/div>\n\n\n