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.  ...
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.