substraction in previous rows on a current filter

[Anonymous]

i am trying to subtract previous lines to get the number of seconds of two times. i always need the calculation for my selected filter as my data set is too large and an error message comes up. i always need the calculation of times for my selected view based on the filters not for the complete file.  

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _last=
MAXX(
    FILTER(ALLSELECTED('Table'),
    'Table'[Date1]<MAX('Table'[Date1])),[Date1])
return
DATEDIFF(
    _last,MAX('Table'[Date1]),SECOND)

2. Result:

Before filtering:

After filtering:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

can you tell me also how i can calculate the average time of the row?

thank you for your help

[lbendlin]

You would use the OFFSET function for that. Give it a try.