Forum Discussion

RBear's avatar
RBear
Icon for Advocate I rankAdvocate I
7 years ago

Handling 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...
Need Help
  • RBear's avatar
    RBear
    Icon for Advocate I rankAdvocate I
    7 years ago

    Thanks; 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)).

  • RBear's avatar
    RBear
    Icon for Advocate I rankAdvocate I
    7 years ago

    Now that I have tried your measure - close, but no cigar :(

     

    First, Measure appears in the report as a column - that won't work because (i) it presents the same information in all rows, which is superflous and (ii) it has to be presented as a row. The second issue can be resolved by going to the formatting options of a Matrix. Format > Values > Show on rows > On

     

    That options is better, but results in this:

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    I don't know how to suppress the first two rows displaying Measure, such that only the bold, bottom row appears. The final version should look like this:

     

     

     

  • RBear's avatar
    RBear
    Icon for Advocate I rankAdvocate I
    7 years ago

    And I just noticed that the measure itself doesn't work: the last column (Total Measure) should have the same values as the 2018 Measure column.