cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
H3nrik Frequent Visitor
Frequent Visitor

Using Parameter to Push Demand Forwards X Days

Hey, 

 

I have three tables called Projects, Demand and DateProject and Demand are connected through ProjectID and Demand and 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. 

 

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. 

 

Current demand

Project Name         January          February           March

Project X                  100h               100h                 50h

Project Y                   50h                 50h                  100h

Project Z                   100h               100h                 0h

 

Demand after Project Y and Project Z have been delayd by one month

Project Name         January          February           March

Project X                  100h               100h                 50h

Project Y                   0h                  100h                 100h

Project Z                   100h               0h                    100h

 

How should I start working on this? 

 

I have tried creating a new measure that changes the date in 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 Projects table and project names, and I've been using that to choose the project which I want to delay. 
2 REPLIES 2
Community Support Team
Community Support Team

Re: Using Parameter to Push Demand Forwards X Days

Hi @H3nrik ,

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  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
H3nrik Frequent Visitor
Frequent Visitor

Re: Using Parameter to Push Demand Forwards X Days

Hello, and thank you for your reply. 

 

I tried to create a dummy example that you will find attached. Here are also some screenshots. 

 

Link to dummydata: https://drive.google.com/open?id=19yv7l8lLtHApMmDoKApsRcQj2Y7xv3kX 

 

Capture3.PNGCapture4.PNG

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors