Comparing Multiple Date Fields

[hmeltonPSL]

I have 4 date fields.  Date Ordered, Date Shipped, Date Received, Date Created.  I want to compare the dates in each field with each other to find which is the newest date then assign a field with value of the field name to show what stage the order is in.  Does anyone have any ideas or a different approach?  Thanks

DAte Created  7/1/2023

Date Ordered 7/3/2023

Date Shipped

Date Received

Stage = Ordered

DAte Created  7/1/2023

Date Ordered 7/3/2023

Date Shipped 7/13/2023

Date Received

Stage = Shipped

[vicky_ · Accepted solution]

Rather than comparing dates, I just thought to look for which statuses have a value to determine the status. I'm assuming here, that the order of statuses is Create > Order > Shipped > Received. 

Here's the measure I used:

Status = 
var _ordered = SELECTEDVALUE('Table'[Ordered])
var _shipped = SELECTEDVALUE('Table'[Shipped])
var _received = SELECTEDVALUE('Table'[Received])
return SWITCH(TRUE(), 
    ISBLANK(_received) && ISBLANK(_shipped) && ISBLANK(_ordered), "Created",
    ISBLANK(_received) && ISBLANK(_shipped), "Ordered",
    ISBLANK(_received), "Shipped", 
    "Received"
)

You'll probably need to make some tweaks for it to work for your specific data though.

[Ahmedx · Accepted solution]

Is this what you are looking for?

[hmeltonPSL]

Yes it is...thank you

[vicky_ · Accepted solution]

Rather than comparing dates, I just thought to look for which statuses have a value to determine the status. I'm assuming here, that the order of statuses is Create > Order > Shipped > Received. 

Here's the measure I used:

Status = 
var _ordered = SELECTEDVALUE('Table'[Ordered])
var _shipped = SELECTEDVALUE('Table'[Shipped])
var _received = SELECTEDVALUE('Table'[Received])
return SWITCH(TRUE(), 
    ISBLANK(_received) && ISBLANK(_shipped) && ISBLANK(_ordered), "Created",
    ISBLANK(_received) && ISBLANK(_shipped), "Ordered",
    ISBLANK(_received), "Shipped", 
    "Received"
)

You'll probably need to make some tweaks for it to work for your specific data though.

[hmeltonPSL]

This also worked.  Thanks for the help!