How to get the last entry blank

[hish]

Hello everyone,

I am trying to get the last entry blank. In the column Duration I am calculating the duration of t_stamp (i+1) - t_stamp (i). I am using this fornula to get the last entry blank.

Can someone help me?

[bhanu_gautam · Accepted solution]

@hish , Try using

DAX
Duration =
VAR CurrentIndex = 'Dataset 1'[Index]
VAR NextTimestamp = CALCULATE(
MIN('Dataset 1'[t_stamp]),
FILTER(
'Dataset 1',
'Dataset 1'[Index] = CurrentIndex + 1
)
)
RETURN
IF(
ISBLANK(NextTimestamp),
BLANK(),
NextTimestamp - 'Dataset 1'[t_stamp]
)

[hish]

Thanks!