Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello PBI Gurus,
I am after your assistance with a query that can duplicate rows based on date & frequency of occurance to generate a work schedule calendar, where an employee has different schedules, eg work a 9 day fortnight, part time Mon to Thur, Weekends, etc.
Data contained in first excel sheet from a single row to duplicate the row at each date occurance, with the end result a visual calendar of employee availability
https://drive.google.com/open?id=162619nHpiwsW6IytsnLhs0mbzNl-hmOH
Appreciate any assistance with this one as with my initial calendar, I entred RDO frequency manually for a small hanful of employees and is not viable for the scale of data I have for 1500 employees and frequency of schedules to change.
Solved! Go to Solution.
I managed to figure it out (there maybe a better way of doing it thou).......
I added an Index column against each individual entry and then added a new column:
=List.Dates(Date.AddDays([EventDate],[#"Frequencey"]),[Occurance],Duration.From(#"Frequency"]))
And it worked
I managed to figure it out (there maybe a better way of doing it thou).......
I added an Index column against each individual entry and then added a new column:
=List.Dates(Date.AddDays([EventDate],[#"Frequencey"]),[Occurance],Duration.From(#"Frequency"]))
And it worked
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |