Forum Discussion

PhineasT's avatar
PhineasT
Helper I
3 years ago
Solved

Create Date Time and Shortest Wait Time Measures

I am working on a dashboard that provides various Date and Time outputs. I need to create a measure or two that will show the 'Date and Time' (in one) associated with the 'Shortest Wait Time' (in ...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

you may want to rethink your data structure. As it is it cannot handle tickets that are open across day boundaries. "Ticket Date"  should be eliminated, and "In Time"  and "Out Time" should be renamed "In DateTime" and "Out DateTime".

  • PhineasT's avatar
    PhineasT
    Helper I
    3 years ago

    And then what?

    Also, I don't understand your comment..."As it is it cannot handle tickets that are open across day boundaries."

    I merely want a card that contains the date and time (just the date in MM-DD-YYYY form will do), and another card that contains the shortest wait time on that date and the time of day of that Shortest wait time. 

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      Let's say the "In Time" for a ticket is 11:55pm and the "Out Time"  is 02:05am.

      • PhineasT's avatar
        PhineasT
        Helper I
        3 years ago

        Let's assume such an occurence is not possible. 

        That all actions happen within a 24 hour period, with most happening between 04:00 and 20:00.

        Seems I should be able to click on a calendar slicer - picking a day/date; There may be hundreds of 'Tickets' on that date/date. This action should populate card with the 'Shortest Wait Time' on that given day/date.

        Is this not possible?

        Something like this, except the desired ouput is 'Shortest Wait Time' rather than 'Earliest Start'.

        Earliest Start =
MINX (
    CALCULATETABLE (
        Table_Roster,
        ALLEXCEPT ( Table_Roster, Table_Roster[Date], Table_Roster[Name] )
    ),
    Table_Roster[Start]
)