Adding Conditional Columns

Conditional columns allow you to create new columns based on logical conditions — similar to IF statements in Excel.

What is a Conditional Column?

A column whose values are determined by rules/conditions applied to existing data. It's a powerful way to categorize, label, or transform data without writing code.

Creating a Conditional Column

Steps:

1. Go to Add Column tab in Power Query
2. Click Conditional Column
3. In the dialog box:

• New column name: Enter the name for your new column
• Column Name: Select the column to evaluate
• Operator: Choose a comparison operator (equals, greater than, contains, etc.)
• Value: Enter the value to compare against
• Output: Enter the result if the condition is true

1. Add more conditions using Add Clause
2. Set the Otherwise value (default if no conditions match)
3. Click OK

Example: Categorizing Sales

Available Operators

Custom Columns (M Formula)

For more complex logic, use Add Column → Custom Column and write an M expression.

Example M Expression:

if [Sales] > 10000 then "High"
else if [Sales] > 5000 then "Medium"
else "Low"

Conditional Column vs DAX Calculated Column