Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculation in previous row

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.  ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , You have to create a measure

 

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

 

or

 

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I got this Error.