Forum Discussion
What-if parameter to offset individual projects
Hello all experts!
I've created some parameters to manipulate a resource planning visual, but the parameters are pretty clunky and affect "everything". I would like to be, expecially for the "project delay" parameter, be able to chose a project and offset only that project.
Is that possible? I've no good idea where to start, so I'm hoping someone could help me?
3 Replies
foging , You have to create that many offset and then you can have measure like
Switch(Max(Table[Project])
"Project 1", [Offset 1 Measure],
"Project 2", [Offset 1 Measure],
// add others
1 //default value
)
Ok, I think I got it now, thanks amitchandak !
One question remains. This has to be hardcoded, right? No way to let new projects come in automatically? No way to create a drop down to select project and offset it individually?
I've tested the Switch function, but I don't understand where to put it and how to use it for individual delay of a specific project. I would attach a pbix if I could, but can't find where to do it.
Edit: Use this link for the pbix: https://drive.google.com/file/d/1bt5DvZdGEdzS02ZUtNTl6eLBxjJ3fSH6/view?usp=sharing
