Forum Discussion
Cumulative Bar Graph based on date
Hi,
I need some assistance where I need to do the following:
I need to display a Bar Graph with the total people employed (date ) by Deparment. It needs to be cumulative and split by departmernt.
I have a date created and a date abolished (important as a position can be removed and another created)
So if it was abolished in 2016 and another was created in 2016 it will be a nil effect in the cumulative total.
I have the date created connected to my date table which is broken up by year and fiscal year.
9 Replies
Hi Anonymous ,
Please illustrate your requirement with sample data and desired output.
How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
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])))IThe 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
