finding dates for weekday in the future

[lawada]

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  ?

[selimovd]

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.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic