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.
in our business we have a feature that lets users book a timeslot and weekday to recieve their service , for example ,user X booked his service to be every Friday 10:00 AM , user Y has booked his service to be every Tuesday 1:00 PM
So user X will recieve his service every Friday 10:00AM and user Y will recieve his serive every Tuesday 1:00 PM
the request is :
create a matrix for every future date , how many users have booked a specific timeslot , ex:
tuesady 06-29-2021 | Wednesday 06-30-2021 | Thursday 07-01-2021 | Friday 07-02-2021 | Saturday 07-03-2021 | Sunday 07-04-2021 | Monday 07-05-2021 | tuesady 07-06-2021 | Wednesday 07-06-2021 | Thursday 07-07-2021 | Friday 07-08-2021 | |
10:00 AM | 1 User | 1 User | |||||||||
11:00 AM | |||||||||||
12:00 PM | |||||||||||
1:00 PM | 1 User |
| 1 User |
so as you can see , dates are in the futute , and do not exist in our database ,
the data i have is :
-User ID
-weekday
-time
-service date ( data will be shown once service date has passed , if the date hasnt come yet , data will be NULL)
ex for the table :
User ID | Week day | Time | Serive date |
124 | Tusday | 6:00 PM | 6/27/2021 |
567 | Friday | 11:00 AM | NULL |
566 | Sunday | 4:00 PM | NULL |
433 | Friday | 3:00 PM | NULL |
so how can i find for each weekday and time the date for it in the future evey month ?
Hey @lawada ,
create a calendar table that is reaching for the future and then do a cross join with your appointment table.
I personally would maybe do that already in the source as you can re-use it. But it's also possible in Power BI.
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 |
---|---|
47 | |
26 | |
19 | |
15 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
21 | |
19 |