Power BI If Statements – Example

power-bi-if
Spread the love

Introduction

Power BI IF statement is used to check whether a condition is met, it return one value if TRUE and other value if FALSE.

Syntax:

IF( Condition, Value if True, Value if False)

Return Type is single value i.e. Scalar.

Example:

Suppose you have a table with column ‘PARKING_SPACE_QTY’

Suppose you want to add a new column ‘Parking’ where the value is ‘Yes’ if parking space exist and ‘No’ if parking space does not exist.
Here is how you can do that

Click ‘New Column’ option in Columns tools

Write the IF statment in the DAX editor and press enter

new column will appear and you can check it has ‘Yes’ as value for parking space when it is available and ‘No’ if its not available.

Hope now you understand the use of IF Statement in Power BI

Read More:
Power BI IF DAX
Power BI Line Chart

Thanks For Reading!