I would like to ask your help on ho to reflect this challenge in DAX.
I would like to count employees who are active each month and would like to count the divisions they belong to. The tricky part on the division count would be if Employee A is on DIV#1 last Sept then transferred to Div#2, then the count for Sept is 1 for Div#1 and Div#2 is zero but come Octboer, the count would be Div#1=0 and Div#2=1.
Below is a sample dataset and succeeding tables would be the desired results.
| Employee | Division | Effective Start Date | Effective End Date | Director |
| John Doe | Customer Support | 01/04/2022 | 9/24/2023 | 1 |
| Billy Sheehan | Customer Support | 06/04/2019 | 12/31/9999 | 1 |
| Paul Gilbert | Finance | 06/06/2006 | 12/31/9999 | 2 |
| Jane Doe | Finance | 3/20/2015 | 2/27/2019 | 2 |
| Pat Torpey | Logistics | 1/20/2024 | 03/02/2024 | 3 |
| Jane Doe | Logistics | 06/05/2008 | 3/19/2015 | 3 |
| Jane Doe | Marketing | 2/28/2019 | 04/04/2024 | 4 |
| John Doe | Operations | 9/25/2023 | 12/31/9999 | 5 |
| Eric Martin | Supply Chain | 03/02/2024 | 12/31/9999 | 6 |
| Result A: | | | | | | | | | | | | |
| Employee | 202401 | 202402 | 202403 | 202404 | 202405 | 202406 | 202407 | 202408 | 202409 | 202410 | 202411 | 202412 |
| John Doe | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Jane Doe | 1 | 1 | 1 | 1 | | | | | | | | |
| Paul Gilbert | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Eric Martin | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Billy Sheehan | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Pat Torpey | 1 | 1 | 1 | | | | | | | | | |
| Result B: | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| Division | 202401 | 202402 | 202403 | 202404 | 202405 | 202406 | 202407 | 202408 | 202409 | 202410 | 202411 | 202412 |
| Customer Support | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Marketing | 1 | 1 | 1 | 1 | | | | | | | | |
| Finance | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Suppy Chain | | | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Logistics | 1 | 1 | 1 | | | | | | | | | |
| Operations | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
