Hi,
I have a project, where I need to add a time shift for a few cases. My original data contains an amount, the project and the years.
Now I implemented the possibility to move the different projects in time. I can move all projects or only a few of them by a fixed number of years. For this, I use a filter for the time shift, e.g. the user can choose a number between 0 and 20 to move the project and a filter for the projects, where the user can choose one or more projects which should be moved by the time in the filter.
Now comes the problem, I need to move different projects by a different amount of years, e.g. project A should move 5 years, Project B should not move at all and Project C should move two years in time.
Sample data set:
| Year | Project | Amount |
| 2021 | A | 5 |
| 2021 | B | 10 |
| 2021 | C | 10 |
| 2022 | A | 10 |
| 2022 | B | 5 |
| 2022 | C | 2 |
After the example time shift from above, the table should look like this:
| Year | Project | Amount |
| 2021 | B | 10 |
| 2022 | B | 5 |
| 2023 | C | 10 |
| 2024 | C | 2 |
| 2026 | A | 5 |
| 2027 | A | 10 |
Any idea how to do that nicely? I have seen a solution where I need to generate a measure for each project and then a filter for each project, giving the start year. This is too complicated and not really applicable. This project should than be rolled out to the next department, where there is another number of projects, so it should be as general as possible.
I guess, a possibility could be to restrict the possible shift to only 5 different years, then I would need 5 filters for the time shift and 5 for the project. But not sure if that would be the best.
Maybe there is someone who has a good idea!
Regards,
Tobias
