Generate Monlthy Rows based on Start and End date

[jay_hl]

Hi All

I am trying to sum up the number of employees we will have per month (across multiple years).  The dataset has their start and end date, but I am having a mental block on the correct logic to generate a row per month based on the the two fields (a start and end date).  Both fields are formatted as Alteryx dates already.  

Both dates can exist for any day of the month, so I would like to have a row per month so I can then count up.  For example an employee starts on 2nd Feb 2025 and is expected to end on 15th October 2025, I would need all 9 rows (months) from Feb to October inclusive:  2025-02 ...... 2025-10

Hope you can plese help

Jay

[alexnajm · Accepted solution]

check out the example for the generate rows tool!