Add an index column first in Query Editor mode.
Then, create a calculated column with below DAX.
MAX ( Table4[Task Date] ),
FILTER ( Table4, Table4[Index] = EARLIER ( Table4[Index] ) - 1 )
Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.