While DAX's DATEDIFF function supports finding the number of hours, minutes, or seconds between two DAX date/time values, this function does not take into account working hours. This recipe demonstrates how to determine the number of minutes between two DAX date/time values taking into account the working hours in a day.
Determining network duration
Getting ready
To prepare for this recipe, do the following:
- In Power BI Desktop, use an Enter Data query to create a table called R05_Table with the following data:
|
Start |
End |
|
8/2/2019 16:00 |
8/6/2019 7:30 |
|
7/26/2019 17:30 |
7/30/2019 8:00 |
|
7/26/2019 17:30 |
7/29/2019 8:00 |
|
7/27/2019 17:30 |
7/30/2019 8:00 |
|
8/6/2019 10:00 |
8/6/2019 16:00 |
|
8/6/2019... |
