Forum Discussion
RBear
Advocate I
Advocate IHandling a one-off starting data point?
One frequently encounters situations where you start with a number and periodically increase and decrease it by certain other numbers. For example, population - increase by births, decrease by deaths...
v-frfei-msft
Community Support
Community SupportHi RBear,
We can create a measure as below to achieve your goal.
Measure = 100+ CALCULATE(SUM(Table1[Value]),ALLEXCEPT(Table1,Table1[Year]))
For more details, please check the pbix as attached.
Regards,
Frank
RBearAdvocate I
Advocate IThanks; I'll take a look at your solution, but in the interim - FYI: when I try to open your file I get an error message to the effect that the file is incompatible with my version of PBI Desktop. I have the most recent (Version: 2.63.3272.40461 64-bit (October 2018)).