Forum Discussion

lawada's avatar
lawada
Icon for Helper III rankHelper III
5 years ago

finding dates for weekday in the future

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 ser...
Date
Date and Time
Help required
help with date
Weekday
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

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