Forum Discussion
Recreate Historical Inventory with Production Report
I am trying to recreate historical inventory from a production report. The production report has a Task ID, Work type, Received Date, Processed Date, and Inbox. I want to capture inventory for eac...
Daily Inventory =
VAR TargetDate = Max('Calendar'[Date])
RETURN
CALCULATE(
COUNTROWS('ProductionTable'),
FILTER(
ALL(
'ProductionTable'[ReceivedDate],
'ProductionTable'[ProcessedDate]
),
'ProductionTable'[ReceivedDate] <= TargetDate &&
(
ISBLANK('ProductionTable'[ProcessedDate]) ||
'ProductionTable'[ProcessedDate] > TargetDate)))
Added a ALL() to the filter to remove the effect of the calendar table, and limited down to just the columns to reduce table materialization
The additional ALL came back with the same totals for my graph. I might need to adjust something else.
Thank you for reviewing.