OFFSET IN POWER BI (DAX) with USE CASE | Get Previous Row
Quick video on how to use Offset Function in DAX.
Total Qty (Previous Row) = CALCULATE([Total Qty], OFFSET(-1, ALLSELECTED(DimDate[Year]), ORDERBY (DimDate[Year], ASC)) )
Timestamps
0:00 Offset Function
0:20 Query (Measure)
1:04 Using Measure
1:17 Adding Dimensions
1:42 Adding Gain/Loss Measure