topic Re: Get value from previous row by DAX in DAX Commands and Tips

Get value from previous row by DAX

nbufff — Wed, 23 Oct 2024 07:01:38 GMT

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!

BeaBF — Wed, 23 Oct 2024 08:04:39 GMT

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),

PreviousQty

)

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

BBF

nbufff — Thu, 24 Oct 2024 00:26:10 GMT

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