undefined

[GG_7096]

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

[some_bih]

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

[tamerj1]

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