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 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 ?
Automatically change date based on actual Week & Month
Hi everyone, I have a problem with month - week based results and i didn't find an option that allows me to show the results of each month in filter relative date, what i actually want is a filter that change automatically the actual month showing at the column header and the results, by example: This is my current month and the past 5 months: What i want is that in november the entire information changes automatically and shows me november results and past 5 months: like this: same thing with weeks, show the last 4 week year I want to do it in the dimdate table because there's a lot of values calculated and i want to avoid make a measure for each one, just do it like a date filter Thank you very much for reading.
Multiple Date Format in Same Column
When I import sales data from 3 different companies, the dates are displayed in different formats within the same column ImportedDate CompanyName ActualDate 1/3/2019 US Company Januar 3, 2019 1/3/2019 Oz Company March 1, 2019 1/3/2019 EU Company March 1, 2019 I can identify MMDD vs DDMM because of the CompanyName Field. I do also have a DateDIM, but couldn't quite figure out how to get one field for date that is standardized. I'd like to be able to use a slicer for date to compare product sales between all 3 companies. Any help is appreciated, thanks!
