Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)?
Solved! Go to 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!
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!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |