Calculation between 2 dates based on the same value

Hi MathieuF 

Best if you can share the pbix

You have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).

And plese explain a bit more what exactly the result should look like. Is it in a visual per task_id? Something else?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

MathieuF

1. Place user_id on a table visual

2. Place this measure in the table. It will give you the time in minutes. Change if you want it in another unit

Measure =
SUMX (
    DISTINCT ( Table1[task_id] ),
    VAR mint_ =
        CALCULATE (
            MIN ( Table1[Created_at] ),
            Table1[Name] IN { "task.taken", "task.resume" }
        )
    VAR maxt_ =
        CALCULATE (
            MAX ( Table1[Created_at] ),
            Table1[Name]
                IN { "task.completed", "task.transferred", "task.expired_from_workbin" }
        )
    RETURN
         ( maxt_ - mint_ ) * 24 * 60
)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

MathieuF 

There's no task.expired_from_workbin in your data,  only task.expired_from_step??

Had a quick look (see it all at work in the attached file). The measure seems to work fine for cases like ID

541fe1360f4ca114df0000bc

 

but is slightly off at ID

        56e1917d7765624c6b0001fd

because task 5fcfa098bd0e54813b1340de     appears in two instances ( taken-completed, resume-completed)

 

and yields negative numbers at cases like ID

       4fc675c20f4ca11924008111

where the code works well but the data only has  a task.taken for  taskID 5fd0b96871336830f56f98f2, which messes the result up

 

Dealing with those cases will be trickier but the code can give you a good start. In any case you will need to exactly define all of the possible cases in which the data can appear and, equally important, define how to deal with them

 

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers