Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi I have a table looking like this (coming from Outlook Calender Data):
StartTime | EndTime | Room |
22-01-2019 09:30 | 22-01-2019 11:00 | Boardroom |
23-01-2019 11:00 | 23-01-2019 12:00 | Boardroom |
28-01-2019 14:00 | 28-01-2019 15:15 | Boardroom |
I'm looking to change it through PowerQuery (M) into a table that looks like this:
Start15MinInterval | Room |
22-01-2019 09:30 | Boardroom |
22-01-2019 09:45 | Boardroom |
22-01-2019 10:00 | Boardroom |
22-01-2019 10:15 | Boardroom |
22-01-2019 10:30 | Boardroom |
22-01-2019 10:45 | Boardroom |
23-01-2019 11:00 | Boardroom |
23-01-2019 11:15 | Boardroom |
23-01-2019 11:30 | Boardroom |
23-01-2019 11:45 | Boardroom |
28-01-2019 14:00 | Boardroom |
28-01-2019 14:15 | Boardroom |
28-01-2019 14:30 | Boardroom |
28-01-2019 14:45 | Boardroom |
28-01-2019 15:00 | Boardroom |
The new table therefore has the start time of the 15 minute intervals that, in this case, the "Boardroom" is occupied.
I have the exact same request as you. Were you able to accomplish this? Make my life so much easier @PedervdB
Nope. Not yet.
@PedervdB This is how I did it for every minute:
In the Power Query editor add a custom column
- List.Times([Start Time], Duration.Minutes([End Time] - [Start Time])+1,#duration(0,0,1,0))
Then you expand it out hopfully that helps!
Hi @PedervdB,
We can create a Calendar with time intervals by DAX. There is a case about that, please refer to it for more details, Hope that helps.
https://community.powerbi.com/t5/Desktop/Calendar-with-time-intervals/m-p/475348
Regards,
Frank