cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mali2020
Helper I
Helper I

Calculate difference between two dates in Minutes

Hi all

 

So i have two dates, One is the [Created Date] and One is the [Completed Date].

 

I was able to calculate the difference between these based on Work Days(ie Exclude Holidays and Weekends). 

 

I did this through creating a Date Table with a list of holidays/weekends.

 

So i have the Work Days Between the two Dates. However i am trying to get the Work Minutes. 

 

So say it's Created on 11/05/2021 at 11:50am and closes the same day at 12pm. How can i get this to display the minutes and not only the days? Say between the normal Business Hours of 9am to 5pm? Thanks

 

Mali2020_0-1627533474563.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@Mali2020 , There is blog around business hour. See if that can help

https://exceleratorbi.com.au/calculating-business-hours-using-dax/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@Mali2020 

 

The simplest method is using power query, add a custom column and change the data type from duration to Text. So the below solution is 58days, 23 hrs, 19mins.

 

Vpazhenmsft_1-1627870418300.png

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

 

amitchandak
Super User IV
Super User IV

@Mali2020 , There is blog around business hour. See if that can help

https://exceleratorbi.com.au/calculating-business-hours-using-dax/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Thank you - i actually found Part 2 of the link you sent more useful and easier to digest(and it worked).

For anyone looking at this in the future, the linked provided by Amit works but Part 2 works too: https://exceleratorbi.com.au/calculating-elapses-business-hours-using-dax-part-2/

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors