none
LOOKUP VALUE BASED ON DATE RRS feed

  • Question

  • I have 2 Data tables in Power Pivot. Table inventory shows item’s inventory on those dates.

    Table inventory

    Date

    Item

    Inventory

    5/29/2019

    A111

    1

    5/30/2019

    B222

    2

    5/30/2019

    A111

    1

    6/1/2019

    A111

    12

    6/1/2019

    B222

    1

    6/2/2019

    A111

    3

    6/2/2019

    B222

    2

    6/5/2019

    B111

    1

    6/7/2019

    A111

    4

    6/7/2019

    B222

    1

    6/8/2019

    C333

    9

    7/1/2019

    A111

    4

    7/2/2019

    A111

    4

    7/2/2019

    B111

    6

    How do I get inventory to show their most recent inventory based on the date of transaction in the table transaction. I tried lookupvalue, tried calculate with max. Nothing seems to work. Please help. Thanks.

    Table transaction

    Item

    Date

    Inventory

    A111

    6/1/2019

    12

    B222

    6/7/2019

    1

    A111

    7/2/2019

    4

    B222

    7/2/2019

    6

    C333

    7/2/2019

    9

    Wednesday, July 24, 2019 5:40 PM

Answers