topic Re: undefined in DAX Commands and Tips

undefined

GG_7096 — Tue, 06 Jun 2023 09:47:46 GMT

Good day, I was trying to make a dax to get the previous row value as sample table above. Please advice. Thank u

Re: undefined

tamerj1 — Tue, 06 Jun 2023 10:38:15 GMT

Hi GG_7096
Please try

Previous Delivery_Date = MAXX ( FILTER ( CALCULATETABLE ( VALUES ( 'Table'[Delivery_Date] ), ALLEXCEPT ( 'Table', 'Table'[Item] ) ), 'Table'[Delivery_Date] < EARLIER ( 'Table'[Delivery_Date] ) ), 'Table'[Delivery_Date] )

Re: undefined

some_bih — Tue, 06 Jun 2023 11:05:13 GMT

Hi GG_7096 try this as new column. I hope this help

previous_delivered_Date =

VAR _item=Sheet13[Item]

VAR _deliverydate=Sheet13[delivered_date]

VAR _previous_row=

CALCULATE(

MAX(Sheet13[delivered_date]),

FILTER(Sheet13,

Sheet13[Item]=_item &&

Sheet13[delivered_date]<_deliverydate

)

RETURN _previous_row