Forum Discussion

CaveOfWonders's avatar
CaveOfWonders
Helper IV
4 years ago
Solved

Transfer DAX logic to Power Query Logic

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

Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    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"

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    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"