Forum Discussion
How to have Initial Inventory (Earliest Date Values)+Production-Sales=Remaining Inv. (Matrix Table)
Hello, How would I go about having a dax measure, giving me: Initial Inventory, based on the earliest date found in the date column; + (Sum of Production) - Sum of Sales = Remaining inventory...
amitchandak
Super User
Super Userpa2021 Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hello amitchandak ,
Here's a test version: https://drive.google.com/file/d/156jqQf88WR2m48xPZawyKPuG-2RQDDM0/view?usp=sharing
Appreciate your time/help.