IF

Checks a condition, and returns one value when it’s TRUE, otherwise it returns a second value.

What it does?

Checks a condition, and returns one value when it’s TRUE, otherwise it returns a second value.

Syntax

IF(logical_test, value_if_true, value_if_false)

Returns

Either True OR false Value OR BLANK

What is the IF Function?

The IF Function in DAX is like the wise friend who helps you make choices. It checks a condition and tells you what to do based on whether that condition is true or false. It’s perfect for when you want to turn numbers in decisions

Example 1: The Snack Selector

Imagine you’re at a party with two snack tables: one with healthy snacks and another with delicious (but not-so-healthy) treats. You want to know where to head based on your mood. Here’s how you might set it up:

Snack Choice = IF(Mood[Feeling] = “Healthy”, “Grab some carrots!”, 
“Time for chips!”)

So, if your mood is “Healthy” you’ll munch on carrots. If not, it’s chip time! Who knew moods could dictate snack choices.

Example 2: The Movie Night Rating

You’re hosting a movie night and want to rate how good the films were. Here’s your movie rating:

Movie	Rating
Pulp Data	4
Dances with Dashboards	2
Data Wars: The Spreadsheet Strikes Back	5

To determine if a movie is a “Must Watch!” or “Skip!” you can use:

Watch Recommendation = IF(Movies[Rating] >= 4, “Must Watch!”, “Skip!”)

So, Pulp Data and Data Wars are “Must Watch!” but Dances with Dashboards? Better hit the skip button!

Conclusion: Making Choices Easy!

The IF Function in DAX is your decision-making buddy, turning data conditions into actionable choices. Whether you’re selecting snacks, rating movies, or picking outfits, the IF Function makes life a little more fun and organized.

So, why not give it a try? Your data decisions await!