substract dates and times conditionned to 1 criteria

[NicoLemarchand]

Hi all, 

I'm in trouble with some data I need to compare.

I've a table with some different session_ID and for each I've events with dates (see a sample in screenshot)

I want to compare the sessions on stacked timelines (with the same scale) , so I need to set the first event of each session as t=0 and count the time relative to it.

It suppose, for each session, to substract all times with date of 1st event of the session

For the moment, I can only plot the dates on separate timelines, one for each session (see capture).

Can you help with that ?

I can send you a sample if you want to try something 😉

[amitchandak · Accepted solution]

@NicoLemarchand ,

Based on what I Gor a new column

=datediff(minx(filter(Table, [SessionID] =earlier([SessionID]) ), [timestamp]), [timestamp], second)

[NicoLemarchand]

Thank you...

But something went wrong :

[amitchandak]

@NicoLemarchand , hope you are creating a new column in DAX -https://docs.microsoft.com/en-us/dax/datediff-function-dax

[NicoLemarchand]

Sorry, a mistake with a stupid copy/paste without adapt to my data

Works perfectly :

Thank you very much !