Automatic generation of dates

[maya1989]

Hello

I have employee list with Start date and end date.I have to generate a list  using poewer query whether they have employed for each month from a particular date(say starting of 2017)

                 current table		
Employee	Start date 	         End date
aa	              1/01/2017          	6/03/2017
bb                  1/01/2017	                current date
cc	             1/01/2017	                21/02/2017
dd	              1/01/2017	                25/04/2017

                  Expected table		
Employees	Month	
aa            	1/01/2017	
bb	                 1/01/2017	
cc	                1/01/2017	
dd	                1/01/2017	
aa	                1/02/2017	
bb	                1/02/2017	
dd	                1/02/2017	
bb	                1/03/2017	
dd	               1/03/2017	
bb	                1/04/2017	

I am using excel and power query to do this. The current table is saved in excel and I using power bi to ETL it.

Any ideas how to generate

[parry2k]

see this post https://community.powerbi.com/t5/Desktop/Number-of-items-used-based-on-in-out-date/td-p/144803

[maya1989 · Accepted solution]

Thanks, but it creates the record data for each date and employee

I want to know how many people employed for that month with their name rather than going at date level