Transfer DAX logic to Power Query Logic

[CaveOfWonders]

Hi All, this is probably quite an easy fix, but I can't figure it out. How can I take the logic from the DAX expression below and apply it in power query?

Status =
IF (
    ISBLANK ( 'Table1'[Complete Date] ),
    IF ( 'Table1'[Due Date] < TODAY (), "Overdue", "Open" ),
    IF (
        'Table1'[Complete Date] > 'Table1'[Due Date],
        "Closed - Delayed",
        "Closed - On Time"
    )
)

Thank you in advance

[CaveOfWonders]

Thank you 🙂

[Fowmy · Accepted solution]

@CaveOfWonders 

Add a custom column in PQ:

if  [Complete Date] = null then
    if [Due Date] <  Date.From(DateTime.LocalNow()) then "Overdue" else "Open" else
    if [Complete Date] > [Due Date] then
        "Closed - Delayed" else    "Closed - On Time"