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

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]
)

  

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Create a table variable (via SUMMARIZE)  of the tickets for the current filter context, include the ticket duration  (probably ignore the tickets without end time),  and then do a MINX on that table variable.

    • PhineasT's avatar
      PhineasT
      Helper I
      3 years ago

      Beyond my skill set.

      Can you provide, or do you have a link to, an example of what your are recommending?