I am setting up BI for projects, some of which start in the future and some of which have already started. The data supporting this is essentially flattened, which I'm recognizing is a problem, but haven't had the time to figure out how to pivot it to work nicely with BI and my understanding of the new programming.
So what I'm trying to achieve, using the table below as a very simplified example, is to return a figure of 27,500, which would be the current debt of projects that have started, plus the starting debt of projects that haven't yet started.
Again, my data is flattened, so the "GROUPBY" or "SUMMARIZE" is necessary and I've used them, but only really via cut/paste to make them work rather than a deep understanding of what they're actually doing.
Thanks for your help - because my data is flattened your solution didn't quite work exactly, but it got me where I needed to be. I needed to add a filter to a calculate so the formula looks like this which is essentially 3 measures: (A) total starting debt outstanding per project, (B) starting debt outstanding for projects that have already started and (C) Current outstanding debt for projects that have already started.
The outcome is (A) - (B) + (C). So in the example from the table I provided earlier would be 28,000 - 9,000 + 8,500 = 27,500 to get to the same outcome.