Forum Discussion

GG_7096's avatar
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

2 Replies

  • tamerj1's avatar
    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]
)
  • some_bih's avatar
    some_bih
    Community Champion
    3 years ago

    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