Duration between two data record

[Nouche]

Hi all,

I'm a Power BI beginner and I'm looking for a duration between two data records in a list (a data record for each row)

I tried this

VAR DateEvent =  SELECTEDVALUE(Ecaux[Date])

VAR Prev_DateEvent = CALCULATE ( MAX ( Ecaux[Date] );  FILTER ( ALL ( Ecaux[Date] ); Ecaux[Date] < DateEvent) )

return Prev_DateEvent

But this measure is empty, and i don't understand what is my mistake. I think my filter is not correct, but i don't know why.

Would you have an advice for me?

Thanks in advance

[v-chuncz-msft · Accepted solution]

@Nouche ,

Just use ALL ( Ecaux ) instead.

[Nouche]

@v-chuncz-msft 

Hello

It's very nice , it worked perfectly !

Thank you very much !

Have a good day