Forum Discussion
Cumulative Bar Chart
Hi,
I want to create a chart that shows the number of resources active in a month based on start and end date.
I have three columns, Resource Name, Resource Start Date and Resource End Date. The idea is to show a count of resources per month based on the following logic: Their start date is prior to or during the month and end date is within the month or after the last day of the month. So given the following example, the chart should show the following resources as active in January: x(end date is in January), z(started in January) and e. February should show the following resources as active: y,z and e.
How do I build this chart?
Anonymous , refer if blog can help you this
Or this file can help https://www.dropbox.com/s/bqbei7b8qbq5xez/leavebetweendates.pbix?dl=0
3 Replies
- amitchandakSuper User
Anonymous , refer if blog can help you this
Or this file can help https://www.dropbox.com/s/bqbei7b8qbq5xez/leavebetweendates.pbix?dl=0
- AnonymousNot applicable
Hi Anonymous ,
Can you provide some sample data with expected output which are editable to make your requirement more clear?
Much appreciated.
Best Regards,
KellyDid I answer your question? Mark my post as a solution! - Ashish_MathurSuper User