Ten capacity projects with slicer selectable years to add capacity to baseline capacity.
I have a table of capacity by year for ten years:
and a table with several projects and the resulting capacity that they add:
I also made an individual table for every project that contains all the possible year choices and None:
I need a visualization that lets you select a year via a slicer for each project (or None). The capacity addition for that project then gets added to the capacity for that year and all years after that. For example, if 2021 is select for Project 1 then the capacity table would look something like this:
I was able to create a measure that becomes the selected year fairly easily, but the problem I'm having is that you cannot use measures in Calcualted Columns because the aren't dynamic. So this doesn't work.: