Forum Discussion
kjkreik
2 years agoFrequent Visitor
Rolling Inventory
I have tried to get this to work and have searched all available resources to figure out how to transfer ending inventory to the next day's beginning inventory. I have a table (Inventory) that is al...
Ashish_Mathur
2 years agoSuper User
Hi,
I have solved a similar problem in the attached files.
Hope this helps.
- kjkreik2 years agoFrequent Visitor
Any reason day 0 closing inventory wont transfer to day +1 opening inventory? Days after +1 all work correctly. I double checked all DAX to make sure it matches your example2 file.
- Ashish_Mathur2 years agoSuper User
No idea. If day 3 onwards are working fine, day 2 should work fine as well. Recheck all the measures.
- kjkreik2 years agoFrequent Visitor
Here is your example2 file when I drop dim_date[cal_date].