Forum Discussion
undefined
Good day, I was trying to make a dax to get the previous row value as sample table above. Please advice. Thank u
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