Simplify an date arithmetic equation?

[Mic_L_Angelo]

Questions folks

I got a formula I’m using to get the number of days between a date in the current row from the date in the preceding row

HOUR(MAX(SELECT(The Feed_Raw[Date], [_THISROW].[_RowNumber] > ([_RowNumber]-1))) - MAX(SELECT(The Feed_Raw[Date], [_THISROW].[_RowNumber] > [_RowNumber]))) / 24

Works fine, but it’s adding 2-3 minutes of sync time (the data set has about 2600 rows). It feels clunky to me

Any ideas to make this equation simpler to cut down sync time? (I need to access all the rows, so I’m not interested in solutions to slice the data sheet)

Appreciate any help