Power BI IF statement is used to check whether a condition is met, it return one value if TRUE and other value if FALSE.
IF( Condition, Value if True, Value if False)
Return Type is single value i.e. Scalar.
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
Thanks For Reading!