Forum Discussion
Grouping two different date fields on a common axis
Super Userjay_za , seem very similar to HR analytics problem, Please find the blog and attached files after signatures
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
Thanks very much, amitchandak. That's a very useful post and I've bookmarked it for future use. Lots of great info in there.
In this particular case, however, I'm looking to group counts of two separate date fields on a common date axis. If I use your data as an example, it would be start and end date. I want to be able to have an X axis showing months (e.g. Jan 2015, Feb 2015, Mar 2015, etc) and the number of joiners and leavers during that month. So again using your data as the sample:
Jan 2015: 2 started (A, B), 0 ended
Feb 2015: 1 started (C), 0 ended
Mar 2015: 1 started (D), 0 ended
...
Oct 2015: 1 started (J), 1 ended (G)
If I use start date as the X axis, the end dates would be counted along with the start dates e.g. G's end date would be counted as a someone leaving, but it would be counted as leaving in Jun 2015, the start date.
Do you perhaps know of a way around this?