Forum Discussion
Calculation between 2 dates based on the same value
Hello, I am having difficulty implementing a calculation in Power BI. I'm looking to calculate the time (Created_at) between the start of the action (Name: task.taken or task.resume) and the end of...
Hello @AIB,
Thank you for your help.
I have another question.
How do I make it take into account only the next action of the same task (task_id)?
Indeed, the 4 lines are the same tasks. Line 318 must go with line 376 and line 1202 with 2174.
With the given formula (and I thank you once again), calculate the time between line 318 and 2174, i.e. 155 minutes instead of 79 minutes (7 + 72).
Thanks in advance.
Mathieu
Hello,
I advance a little bit ...
I managed to get the calculation of the first part but I cannot sum the 2 parts.
Namely from 8:44 am to 8:51 am + 10:08 am to 11:20 am.
7 + 72 min
How to do ?
Here is the new file.
Thanks in advance.
Mathieu
Fichiers: https://www.dropbox.com/sh/61ae2dtbmobl8tp/AAATpy0sRBMGRziU0Xe7Sy_Za?dl=0