Forum Discussion
foging
3 years agoFrequent Visitor
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 "pro...
amitchandak
3 years agoSuper User
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
)
foging
3 years agoFrequent Visitor
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?