Parameters and Timelines

[2487jbml]

Hey all, 

Fairly new to Power BI and am having trouble finding the right thing to search for I guess.  I am working on a project where we need to asses a delivery cadence.  We have a team that is working on prior deliveries and will be taking on new deliveries.  There area  set amount of deliveries, say 1500 for the prior contract and 2200 for the upcoming contract.  I need a way to be able to adjust the amount of old delivery customers serviced and amount of new delivery customers serviced Monday through Thursday.  There are fees and such tied to both, so trying to minimize the charges to the company.  There won't be any duplicate deliveries, distance is not an issue, but there is some level of complexity with some deliveries.  Any ideas of how I can accomplish this?  

Thanks in advance, I look forward to learning this! 

[2487jbml]

Hey Greg, 

I'll try to explain better.  I'm thinking of something like this for the table structure.  But I would need to be able to allow my user to adjust how many deliveries are made from the old contract and from the new contract so that we can find the optimal combination for an ideal timeframe.  Below, 40 deliveries are done a week from the prior contract and 10 from the new.  However, my users will need to be able to see what would happen if we adjusted by x days.  I think putting in a couple of sliders to manipulate the calculation could do, but I'm just not that experienced and am sure there is a better way.  

Week End	Prior Deliveries Left	New Deliveries Left	Month Completion
3/28/2020	3150	2200
4/4/2020	3110	2190	200
4/11/2020	3070	2180
4/18/2020	3030	2170
4/25/2020	2990	2160

[dax]

Hi @2487jbml , 

I am not clear about your requirement, what did you want to get? And what is "Month Completion" and its logic ? If possible could you please inform me more detailed information(such as your expected output and your sample data ( by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Very tough to answer with no sample data and expected output. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490