Forum Discussion
Cumulative Bar Graph based on date
Hi,
I have tried a few ways and sorry I have not added.
I have a Positions Table with a Date Approved field linked to the Date field in my Date Table.
Count FTE Measure = sum(Positions[FTE])
Cumulative FTE =
CALCULATE([Count FTE Measure],
FILTER(ALLSELECTED('Date'[Date]),
'Date'[Date] <= MAX('Date'[Date])))I The date table has Dates, Months, Years, Fiscal Years etc
The issue I have is I need to have a cumulative count of all Active position in the year in a bar chart.
But I also have to report how many Date Abolished have been made in that year. The Date Abolished fireld is in the Positions Table
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 think the issue is that the Date in the Date table is connected to the Dtae Approved in the Positions Table but I also need to use the Date Abolished which is not linked to a Date Table
Any Ideas
Hi,
I have tried to attached some sample data.
Can anyone assist please.
https://docs.google.com/spreadsheets/d/1XyPTXzbveQtXiPTQZcSXN_4UWT8c69PE62MVnp0iw7w/edit?usp=sharing
Hi,
This is a start. You may download my PBI file from here. I have not computed the cumulative total, just the net additions per year. Are the net addition figures correct?
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.
