Get value from previous row by DAX

[nbufff]

Hello, I stuck in the DAX formual by tring to get value from previous row.

With Below example, when Date and SKU are same:

D3=D2

D4=D3

D6=D5

....

How can we achieve that by adding Column D (Qty2) in using DAX?

Thanks for help!

[nbufff]

@BeaBF THANKS for help, it's working on my side!

[BeaBF · Accepted solution]

@nbufff Hi! Create a new calculated column with this code:

Qty2_col =

VAR CurrentDate = 'Table'[Date]

VAR CurrentSKU = 'Table'[SKU]

VAR CurrentQty1 = 'Table'[Qty1]

VAR PreviousQty =

    CALCULATE(

        MIN('Table'[Qty1]),

        FILTER(

            'Table',

            'Table'[Date] = CurrentDate &&

            'Table'[SKU] = CurrentSKU &&

            'Table'[Qty1] > CurrentQty1

        )

    )

RETURN

IF(

    ISBLANK(PreviousQty),

    0,

    PreviousQty

)

if it's ok, please accept my answer as solution!

BBF