How to Write an IF Statement in Power BI

The IF statement is one of the first functions most people learn in Excel, and for good reason - it’s the key to making your data dynamic. The same holds true in Power BI, where the IF statement lets you create smarter, more context-aware reports and dashboards. This article will walk you through exactly how to write an IF statement in Power BI, starting with the basics and moving to more advanced examples that you can apply to your own data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is the IF Statement in Power BI?

In Power BI, you use a language called DAX (Data Analysis Expressions) to create new calculations from your existing data. The IF function is a core part of DAX and lets you perform a logical test and return one value if the result is true, and another value if the result is false. It’s the primary way to introduce conditional logic into your reports.

Whether you’re creating a new column to segment your customers or a new measure to calculate a conditional sales bonus, the IF function is the tool for the job.

Understanding the DAX IF Syntax

The structure of the IF function is simple and likely feels familiar if you’ve ever used IF statements in a spreadsheet. It takes three arguments (or inputs):

IF(<logical_test>, <value_if_true>, <value_if_false>)

Let's break down each part:

• <logical_test>: This is the condition you want Power BI to evaluate. It must be an expression that returns either TRUE or FALSE. For example, you might check if sales are greater than $1,000 with an expression like [SalesAmount] > 1000.
• <value_if_true>: This is what the function will return if your logical test is TRUE. It can be a static text value (like "High Value"), a number, or another DAX expression.
• <value_if_false>: This is what the function returns if your logical test is FALSE. This argument is technically optional. If you leave it blank, the function will return a blank value if the condition is false. In most cases, you’ll want to specify a value here for clarity.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Creating Your First IF Statement: A Step-by-Step Guide

The best way to learn is by doing. Let's create a calculated column that categorizes sales deals as either "Large Deal" or "Small Deal" based on their value. For this example, we'll assume you have a sales table with a column named SalesAmount.

We need to add a new column to our table. Calculated columns process row by row, making them ideal for categorizing or segmenting data.

Step 1: Navigate to the Data View

In Power BI Desktop, look at the left-hand navigation pane and click on the "Data" icon (it looks like a table). Select the table you want to work with from the Fields pane on the right.

Step 2: Create a New Column

With your table selected, you'll see a "Table tools" tab appear in the top ribbon. Click on "New column."

This will open up the formula bar at the top of the data grid, where you will write your DAX formula.

Step 3: Write the IF Formula

In the formula bar, type the following DAX expression. Power BI will suggest columns as you type, which helps avoid typos.

Deal Size = IF('Sales'[SalesAmount] > 1000, "Large Deal", "Small Deal")

Here’s what’s happening in this formula:

• Deal Size =: This gives our new column a name.
• IF(: This starts the function.
• 'Sales'[SalesAmount] > 1000,: This is our logical test. For each row, it checks if the value in the SalesAmount column of the Sales table is greater than 1000.
• "Large Deal",: This is the value_if_true. If the sales amount is over 1000, the column will get the text "Large Deal".
• "Small Deal"): This is the value_if_false. If the sales amount is not over 1000, the column will get the text "Small Deal".

Step 4: Press Enter and See the Result

Once you press Enter, Power BI will calculate the value for every row in your table and populate the new Deal Size column. You can now use this new column in your visuals, charts, and slicers to analyze your data by deal size.

Practical Examples of IF Statements in Power BI

Now that you've got the basics down, let's look at a few more common scenarios where IF statements are incredibly useful.

Example 1: Checking for Text Values

You can also use the IF function to check for specific text values. Imagine you have a Products table with a Category column and you want to create a new column that helps you identify high-margin electronics.

Priority Product = IF('Products'[Category] = "Electronics", "High Priority", "Standard")

This formula checks each row in the Products table. If the Category is exactly "Electronics," it assigns "High Priority", otherwise, it assigns "Standard."

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Example 2: Handling Blank Values with ISBLANK

What if a field is empty? Empty or BLANK() values can cause issues in calculations. The ISBLANK() function is a perfect partner for IF. Let's say you have an Orders table with a ShippedDate column. We can use IF to create a more user-friendly status column.

Order Status = IF(ISBLANK('Orders'[ShippedDate]), "Processing", "Shipped")

This formula first checks if the ShippedDate for an order is blank. If it is, the Order Status is set to "Processing." If there is a date in the ShippedDate field, the status is set to "Shipped."

Example 3: Nesting IFs for Multiple Conditions

Sometimes you have more than two possible outcomes. You can handle this by "nesting" one IF statement inside another. A nested IF simply places another IF function in the value_if_false part of the parent IF.

Let's expand our "Deal Size" example to include a "Medium Deal" category.

• Large Deal: > $5,000
• Medium Deal: > $1,000
• Small Deal: <= $1,000

Here’s the nested IF statement to accomplish this:

Deal Tier = IF( 'Sales'[SalesAmount] > 5000, "Large Deal", IF( 'Sales'[SalesAmount] > 1000, "Medium Deal", "Small Deal" ) )

Let's unpack this:

1. The outer IF statement first checks if SalesAmount is greater than 5000.
2. If it's true, it returns "Large Deal" and stops.
3. If it's false, it moves to the value_if_false section, which contains our second, nested IF.
4. The inner IF then checks if SalesAmount is greater than 1000.
5. If this is true, it returns "Medium Deal."
6. If not, it returns "Small Deal."

The SWITCH function: A Cleaner Alternative to Nested IFs

While nested IF statements work, they can become hard to read and manage if you have many conditions. For these situations, Power BI offers a more elegant solution: the SWITCH function.

The SWITCH function evaluates an expression and compares it against a list of values, returning a result when it finds a match. A common pattern for replacing complex nested IFs is SWITCH(TRUE(), ...), which checks a series of logical conditions.

Let’s rewrite our Deal Tier calculation using SWITCH:

Deal Tier (SWITCH) = SWITCH(TRUE(), 'Sales'[SalesAmount] > 5000, "Large Deal", 'Sales'[SalesAmount] > 1000, "Medium Deal", "Small Deal" )

This formula does the same thing as the nested IF but is much cleaner. SWITCH(TRUE()) goes through each condition in order (SalesAmount > 5000, SalesAmount > 1000, etc.), and the moment it finds one that is true, it returns the corresponding result and stops. The final value ("Small Deal") acts as the default if none of the previous conditions are met.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Combining IF with AND and OR

For more sophisticated logical tests, you can combine IF with logical operators like AND (&&) and OR (||).

The AND function is perfect for situations where multiple conditions must be true.

Example with AND

Imagine you want to flag high-value deals from a specific region for a special sales bonus. You only care about deals that are both over $5,000 and in the "North" region.

Bonus Eligible = IF( AND('Sales'[SalesAmount] > 5000, 'Sales'[Region] = "North"), "Eligible", "Not Eligible" )

Example with OR

The OR function works when only one of several conditions needs to be true. Let’s say a product is considered a high-priority item if its category is either "Software" or "Services."

Priority Status = IF( OR('Products'[Category] = "Software", 'Products'[Category] = "Services"), "High Priority", "Standard" )

Final Thoughts

The IF statement is a fundamental building block for data analysis in Power BI, allowing you to move beyond raw data and create meaningful, rule-based classifications and calculations. By mastering IF, nesting it for multiple conditions, or choosing the cleaner SWITCH function, you unlock a deeper level of insight in your reports.

As you build more complex reports, you might find yourself spending a lot of time writing DAX and wrestling with formulas. We built Graphed because we believe getting insights from your data shouldn't require you to become a DAX expert. By connecting your data sources, you can ask questions in plain English like, "Show me a chart of sales by deal size tier for the North region," and we handle the complex logic for you, delivering live, interactive dashboards in seconds. It’s all about getting to the answers faster, without the headache.