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. 

Thank you for your time

4 Replies

  • amitchandak's avatar
    amitchandak
    Super 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. 

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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?

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    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.