topic Calculation in previous row in DAX Commands and Tips

Calculation in previous row

Anonymous — Mon, 23 Jan 2023 16:47:31 GMT

Hello Guys i have a problem,

i get my data via directquery but i want to calculate everytime with previous rows. I want to get the seconds between every rows.

Here is a example of it.

Thank you for your time

Re: Calculation in previous row

amitchandak — Mon, 23 Jan 2023 18:05:38 GMT

Anonymous , You have to create a measure

datediff(maxx(filter(all(Table), Table[Date] < max(Table[Date]) ), Table[Date]) , Max(Table[Date]) , Second)

Sumx(Table, datediff(maxx(filter(all(Table), Table[Date] < max(Table[Date]) ), Table[Date]) , Max(Table[Date]) , Second) )

Re: Calculation in previous row

Anonymous — Tue, 24 Jan 2023 11:56:29 GMT

I got this Error.

Re: Calculation in previous row

FreemanZ — Tue, 24 Jan 2023 12:31:57 GMT

hi Anonymous

try to plot the date1 column with a measure like:

MinuteDuration = VAR _date = MAX(TableName[Date1]) VAR _datepre= MAXX( FILTER(ALL(TableName), TableName[Date1]<_date), TableName[Date1] ) RETURN DATEDIFF(_datepre, _date, MINUTE)+0

it worked like this:

Please ensure to feed the Date1 column directly, instead of the date hierarchy.

Re: Calculation in previous row

Anonymous — Wed, 25 Jan 2023 11:22:44 GMT

Do you know how i get this measure for only the rows that i got shown on my table and not for all of my over 1 000 000 rows?