cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhmiller89 Member
Member

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 

3 REPLIES 3
v-xjiin-msft Super Contributor
Super Contributor

Re: Wait Time

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
)

3.PNG

 

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.

Highlighted
bhmiller89 Member
Member

Re: Wait Time

@v-xjiin-msft

That didn't seem to work.

 

Capture.JPG

 

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 Super Contributor
Super Contributor

Re: Wait Time

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.

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 125 members 1,904 guests
Please welcome our newest community members: