Forum Discussion

MathieuF's avatar
MathieuF
Icon for Helper III rankHelper III
5 years ago

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...
MathieuF's avatar
MathieuF
Icon for Helper III rankHelper III
5 years ago

AlB 

Yes it's normal. It is task.expired_from_workbin but it is not present in the example file.


The common point must be task_id and not user_id. The user_id is a filter.

MathieuF's avatar
MathieuF
Icon for Helper III rankHelper III
5 years ago

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