Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
8 years ago

Wait Time

I have "Date Opened" and "Action Date" I need to calculate number of minutes between the open date and the first action date

 

I was thinking something like 

= MIN(ActionDate) - DateOpened

 

because eacch item will have multiple "actions" but I need the time between the item being opened to the first action being taken

 

I feel like I"m on the right track but not quite there 

Need Help

3 Replies

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    Hi bhmiller89,

     

    Did you mean this?

     

    Measure with DATEDIFF() function:

     

    Wait Time =
DATEDIFF (
    MAX ( 'Action'[DateOpened] ),
    CALCULATE (
        MIN ( 'Action'[ActionDate] ),
        ALLEXCEPT ( 'Action', 'Action'[Actions] )
    ),
    MINUTE
)

     

    If it doesn't satisfy your requirement, please share us some sample data which we can copy and paste directly and its corresponding expected result.

     

    Thanks,
    Xi Jin.

    • bhmiller89's avatar
      bhmiller89
      Helper V
      8 years ago

      v-xjiin-msft

      That didn't seem to work.

       

       

      Here's an Incident that has two actions. I need the number of minutes between the OpenDate and the very first Action StartDate. So in this case it should be somewhere around 38 minutes but the formula is spitting out that weird number. The OpenDate for the Incident and the StartDate of the Action are in two different tables if that matters 

      • v-xjiin-msft's avatar
        v-xjiin-msft
        Solution Sage
        8 years ago

        Hi bhmiller89,

         

        Yes. That matters.

         

        Please share us your table structure and some sample data which we can copy and paste directly. Or if you can share us your pbix file with One Drive or Google Drive, it'll help us a lot to know your actual situation.

         

        Thanks,
        Xi Jin.