minutes

2 Topics

Trying to work out duration with date time columns and another with minutes
Hi there all, I'm trying to work out a total hours and minutes duration between a start time, end time and then add a to the duration. How can I do this in power bi desktop? (I only need the end calculation of the total time in hours and minutes). Thanks
Solved
Anonymous
2 years ago Place DAX Commands and Tips
2.5KViews
0likes
6Comments
Calculate Difference in Time within Column with change in dates
I have a table where i have multiple times throughout a day. I'm trying to calculate the difference between each time change in that day. I also need to start from 0:00 time at each change of date. Is there a formula through dax that would work? I had a formula that worked in excel but will not work within BI. Here is the excel formula: =IF(ISNUMBER(SEARCH("Start",[@Comment])),0,E5-E6). Any help would be appreciated.
Solved
unc49us
4 years ago Place DAX Commands and Tips
2.2KViews
0likes
9Comments