Power BI - Accumulate over time, and Percentage

[Anonymous]

Hi Guys,

I need your assistance here as I am new to Power BI.

November 2021 FIT should be 159 and not 157, and December should be equal to the total of the year as the table should accumulate over time. January 2022 will therefore need to include to total / December 2021 figure in order to continue this journey

I’ve made a small pivot on the data extract, and here you can see, how the FIT% should look on a total basis across requirements:

The above should somehow be presented in a graphical way taking into consideration that total no. of requirements is increasing over time, and that GAP’s can turn into FIT’s and vice versa.

-------

In the table below: Is it possible to add a percentage in the bottom that just calculate the FIT% meaning in September it will be 100%, then it goes down to 67,37 in November and so forth?

Looking at the FIT graph above – September is correct, November is close to it, but I start having hard times – It seems like the GAPS are taking more and more of the majority in relation to the total and therefore this also indicates that no accumulation takes place over time. In February I don’t even understand the blue box, because there are very few requirements falling into this group.

So the red part should overtime be less, less and less taking into consideration that the total number of requirements is growing up to 497 in February starting at 238 in November.

Then (and this is just an idea) for each cell in the above you can then calculate the estimated no. of hours as the sum of requirements, where ((Max dev. Effort – Min dev. Effort) / 3) times 4) gives the value in hrs.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Please try to create a measure like below:

Measure = CALCULATE(SUM('Table'[ID]),FILTER(ALLEXCEPT('Table','Table'[GIT FIT or GAP]),'Table'[Date]<=MAX('Table'[Date])))

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.