Forum Discussion

hmeltonPSL's avatar
hmeltonPSL
Helper II
3 years ago
Solved

Comparing Multiple Date Fields

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 va...
Need Help
  • vicky_'s avatar
    vicky_
    3 years ago

    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's avatar
    Ahmedx
    3 years ago

    Is this what you are looking for?

vicky_'s avatar
vicky_
Super User
3 years ago

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's avatar
hmeltonPSL
Helper II
3 years ago

This also worked.  Thanks for the help!