IF Statements

[Anonymous]

Hi All,

Trying to convert this formula from Excel and Power BI and not too sure how.

=IF([@SNStatus2]="OPEN","Outstanding Due",
IF([@ReceiptDate]<=[@[Due Date]],"On Time","Overdue Completion"))


Tried the following on Power BI but it doesn't work:

IF([SNStatus2]="Open","Open",

IF ([SNStatus2]="Closed","Outstanding Due",

IF([ReceiptDate]<=[Due Date], "On Time", "Overdue Completion")

))

[v-stephen-msft · Accepted solution]

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.

[FreemanZ]

what error do you get?