Forum Discussion
maya1989
9 years agoRegular Visitor
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
2 Replies
- maya1989Regular Visitor
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