Forum Discussion
Project Current Trend into future days issue
Hi psmith-nhs-inc,
Could you post your table structures(including the formula of the measures you're using) with some sample data and the expected result against it? So that we can better assist on this issue. It's better to share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:
Regards
https://dl.dropboxusercontent.com/u/9936354/PurchasingDEVforum.pbix
Top Left: Daily Sales
Bottom Left: Daily Burn rate, average daily sales based on selected slaes range.
Top Right Current Inventory on hand.
Bottom Right is mt current goal.
With a starting inventory of 100, display the date from today until the end of time as defined by my date table, that on hand inventory minus the cumulative Daily Burn Rate, so today shows 98, tomorrow shows 96, the day after shows 94, etc.
Phil
