I’m trying to return the inventory from the minimum day on this table visual.
Ultimately, I would like to calculate the rolling change in inventory from the minimum filtered date. So, the final cumulative total would be - 182,409.
I can’t understand why this formula isn’t working to give me the minimum…
Min Inventory =
SUM( Inventory[Inventory Quantity] ),
FILTER( ALLSELECTED( ‘Date’ ), ‘Date’[Date] = MIN( ‘Date’[Date] ) )
Thank you in advance for all of your help!