Forum Discussion

maya1989's avatar
maya1989
Regular Visitor
9 years ago
Solved

Automatic generation of dates

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

  • 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