IF Statements

Hi Anonymous ,

 

In Power BI Desktop, you can create measures or calculated columns.

The formula you provided belong to the calculated column.

Calculated column =
IF (
    [SNStatus2] = "Open",
    "Open",
    IF (
        [SNStatus2] = "Closed",
        "Outstanding Due",
        IF ( [ReceiptDate] <= [Due Date], "On Time", "Overdue Completion" )
    )
)

Here's the measure you can try. We often use MAX function to reference the current row. The MIN function can also be used, and if it is a numeric type, the SUM function can also refer to the current row.

Measure =
IF (
    MAX ( 'TableName'[SNStatus2] ) = "Open",
    "Open",
    IF (
        MAX ( 'TableName'[SNStatus2] ) = "Closed",
        "Outstanding Due",
        IF (
            MAX ( 'TableName'[ReceiptDate] ) <= MAX ( 'TableName'[Due Date] ),
            "On Time",
            "Overdue Completion"
        )
    )
)

 Power BI: Calculated Measures vs. Calculated Columns | by Rod Castor | Towards Data Science

Calculated Column and Measure in Power BI (powerbiconsulting.com)

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.