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.
Here it is, amitchandak !
Link to download the file:
https://drive.google.com/file/d/1YE2mSPGgvG2Dhyi4alzTbWyNVTPTXvp9/view?usp=sharing
Appreciate your time!