Forum Discussion
Cumulative Bar Graph based on date
Hi,
Thank you Ashish_Mathur for this but it is not what I wanted
I have attached a file if it helps on what I'm trying to get to.
Power BI File ===>> My Power BI File
Hi,
Sharing the PBI file does not help unless you tell me exactly what end result you want to see. I am not interested in the graph. Just show me in a Table the exact result you are expecting.
Thanks Ashish_Mathur
Ok, let me try again.
What I need is the total of FTE (sum) every year as at the end of the fiscal year. So if the position was approved in the F2012, then they are also to be included in the F2013 and so on. They should be included in all years until the position is abolished. Furthermore, there should be a net difference in the abolished so that is there was 3 positions added but there was 5 positions abolished then the net difference in that particular year drops by 2.
Same example as earlier listed again:
Not the actual numbers, I'm just giving an example.
2016 / 2017
Total = 300
2017/2018
Date Approved = 3
Date Abolished = 10
Total = 293
2018/2019
Date Approved = 7
Date Abolished = 3
Total = 297
I hope this helps. I really appriciate any assistance as you can see from the report I have tried different ways.
I need to represent this in waterfall chart showing the differences every year and the total to be correct and the Fiscal years to be right as at the end of that fiscal year.
Can anyone please assist