Equivalent to OFFSET excel funcion

Hi vallrebe ,

You can try to create a calculated column and get the contents of the previous row through TL sorting. Similar DAX as follows.

 col = CALCULATE (
        SUM ( 'Table1'[Dilution] ),
        FILTER (
            'Table',
            'Table'[TL]
                = EARLIER ( 'Table'[TL] ) - 1
                && 'Table'[ID] = EARLIER ( 'Table'[ID] )
        ))

If the problem persists, please create pbix with the sample data and share the link, and describe the results you expect.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.