Using Parameter to Push Demand Forwards X Days

Question

Hey,&nbsp;&nbsp;I have three tables called&nbsp;Projects, Demand and&nbsp;Date.&nbsp;Project&nbsp;and&nbsp;Demand are connected through ProjectID and&nbsp;Demand and&nbsp;Date are connected through date. Currently I have a report where I can see sum of demand hours for each project for selected days. The problem is that sometimes projects get delayd, meaning for example that no work can be done for a month, and the required resourced demand will move forwards one month.&nbsp;&nbsp;I have used what-if parameters before, and managed to create a slicer, which allows the user to choose a project, and adjust the total demand for the project. What I've recently been trying to do is to allow the user to choose a project and for example move the demand forwards one month, like you can see below.&nbsp;&nbsp;Current demandProject Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;January&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; February&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MarchProject X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50hProject Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100hProject Z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0h&nbsp;Demand after Project Y and Project Z have been delayd by one monthProject Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;January&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; February&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MarchProject X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50hProject Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100hProject Z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100h&nbsp;How should I start working on this?&nbsp;&nbsp;I have tried creating a new measure that changes the date in&nbsp;Demand table using the following:Adjusted_TimeByDay = IF (SELECTEDVALUE ( slicer_project[slicer_project] ) = MAX(Projects[Project Name]),DATEADD(Demand[TimeByDay],Parameter[Parameter Value],DAY), DATEADD(Demand[TimeByDay],0,DAY))The slicer_project is a copy of the&nbsp;Projects table and project names, and I've been using that to choose the project which I want to delay.&nbsp;

v-piga-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
To understand your scenario better, please share the data sample which could reproduce your scenario and your desired output so that we could help further on it.
Or, ideally, share the pbix (beware of confidential data).
Best&nbsp; Regards,
Cherry
&nbsp;

anonymous · Answer

Hello, and thank you for your reply.&nbsp;&nbsp;I tried to create a dummy example that you will find attached. Here are also some screenshots.&nbsp;&nbsp;Link to dummydata:&nbsp;https://drive.google.com/open?id=19yv7l8lLtHApMmDoKApsRcQj2Y7xv3kX&nbsp;&nbsp;

Forum Discussion

Using Parameter to Push Demand Forwards X Days

2 Replies

Related content

Sales Summary - Order Demand vs. Forecast Demand

Days Forward Coverage (DFC) Measure

Forward rolling total demand

Parameter in summarize

notebook parameter