Forum Discussion

GG_7096

New Member

3 years ago

undefined

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

tamerj1

Community Champion

3 years ago

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