Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Power BI - Accumulate over time, and Percentage

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

MohammedShaik_0-1646911692488.png

MohammedShaik_3-1646912114247.png

 

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:

 

MohammedShaik_2-1646911830664.png

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?

MohammedShaik_1-1646911752457.png

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.

 

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

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])))

 

Vlianlmsft_1-1647236570102.png

 

 

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

View solution in original post

1 REPLY 1
V-lianl-msft
Community Support
Community Support

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])))

 

Vlianlmsft_1-1647236570102.png

 

 

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors