topic Re: substraction in previous rows on a current filter in DAX Commands and Tips

substraction in previous rows on a current filter

Anonymous — Thu, 23 Mar 2023 12:44:46 GMT

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.

Re: substraction in previous rows on a current filter

lbendlin — Sat, 25 Mar 2023 01:35:14 GMT

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

Re: substraction in previous rows on a current filter

Anonymous — Mon, 27 Mar 2023 02:24:43 GMT

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

Re: substraction in previous rows on a current filter

Anonymous — Tue, 04 Apr 2023 07:49:22 GMT

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

thank you for your help