Inventory Time Series, show what inventory items were added or removed from inventory over time.

[tpmbuu]

I am creating an inventory dashboard to show inventory over time, on the side I would like to display the new data entered from the previous day. For example if March 14 has 100 pieces of inventory and March 15 has 105 pieces, 100/105 are the same as the day prior but there are 5 new items, how can I show the non duplicate (those 5 values)?

[Sahir_Maharaj · Accepted solution]

Hello @tpmbuu,

Can you please try to create a measure to identify new items:

New Items Today = 
VAR CurrentDate = MAX('Date'[Date])
VAR PreviousDate = CurrentDate - 1

VAR ItemsToday = CALCULATETABLE(
    DISTINCT('Inventory'[ItemID]),
    'Inventory'[Date] = CurrentDate
)

VAR ItemsYesterday = CALCULATETABLE(
    DISTINCT('Inventory'[ItemID]),
    'Inventory'[Date] = PreviousDate
)

RETURN
COUNTROWS(
    EXCEPT(ItemsToday, ItemsYesterday)
)

Hope this helps!