Forum Discussion
Inventory Running Total (ERP)
Hello all, My goal is to start with an Inventory figure, dated as today() currently in my report. I want to add incoming (PO's) by date over the next several months, while also subtracting anot...
TomMartens
Super User
Super UserHey Anonymous ,
maybe this blog can become your first step: Using Table Iterators to calculate a future value - Mincing Data - Gain Insight from Data (minceddata.info)
If not, take the time and create a pbix that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures. Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method, share the xlsx as well.
Describe the expected result based on the sample data you provide.
Regards,
Tom