count data for weekdays in the future

lawada — Tue, 06 Jul 2021 08:10:31 GMT

in our business we have a feature that lets users book a timeslot and weekday to recieve their service (weekly or BiWeekly) , for example ,user X booked his service to be Friday 10:00 AM Weekly , user Y has booked his service to be every Tuesday 1:00 PM BiWeekly

So user X will recieve his service Friday 10:00AM (Every Week), and user Y will recieve his serive Tuesday 1:00 PM (Every Two Weeks)

the request is :

create a matrix for every future date , how many users have booked a specific timeslot , ex:

tuesady 07-06-2021

Wednesday 07-07-2021

Thursday 07-08-2021

Friday 07-09-2021

Saturday 07-10-2021

Sunday 07-11-2021

Monday 07-12-2021

tuesady 07-13-2021

Wednesday 07-14-2021

Thursday 07-15-2021

Friday 07-16-2021

Saturday 07-17-2021

Sunday 07-18-2021

Monday 07-19-2021

tuesady 07-20-2021

Wednesday 07-21-2021

Thursday 07-22-2021

Friday 07-23-2021

10:00 AM

1 User

1 users

11:00 AM

12:00 PM

1:00 PM

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	frequency
124	Tusday	6:00 PM	6/27/2021	weekly
567	Friday	11:00 AM	NULL	weekly
566	Sunday	4:00 PM	NULL	biweekly
433	Friday	3:00 PM	NULL	biweekly

so how can i count total users who booked a service each weekday (weekly/biweekly) for dates in the futute?

Re: count data for weekdays in the future

lawada — Tue, 06 Jul 2021 08:15:09 GMT

correction with the matrix example :

User Y should appear in the following dates as he requested his service to be BiWeekly :

Tuesday 07-06-2-2021 Tuesday 07-13-2-2021 Tuesday 07-20-2-2021
1:00 PM UserY ----- User Y

topic count data for weekdays in the future in DAX Commands and Tips

count data for weekdays in the future

Re: count data for weekdays in the future