Forum Discussion

2487jbml's avatar
2487jbml
Frequent Visitor
6 years ago

Parameters and Timelines

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...
Need Help
Tips and Tricks
Tutorial Requests
2487jbml's avatar
2487jbml
Frequent Visitor
6 years ago

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 EndPrior Deliveries LeftNew Deliveries LeftMonth Completion
3/28/202031502200 
4/4/202031102190200
4/11/202030702180 
4/18/202030302170 
4/25/202029902160 
dax's avatar
dax
Community Support
6 years ago

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.