Week over Week sales calculation
I am trying to figure out week over week calculation. I searched online and found DAX measure. I created columns for Year, WeekDay, and WeekNum. what I am using is like below: WoW Rev OTB = SUM ( 'Table'[sales on the book] ) - CALCULATE ( SUM ( 'Table'[sales on the book] ), FILTER ( ALL ( 'table' ), 'table'[Year] = MAX ( 'table'[Year] ) && 'table'[WeekNumber] = MAX ('table'[WeekNumber]) - 1 && 'table'[WeekDay] = MAX ( 'table'[WeekDay] ) ) ) The result turned very well, I got the total number for week over week sales. However, when I tried to apply on different region or destinations or choose other status, the week over week sales numbers showed all negative numbers which doesn't seem correct. (This is the screenshot for WoW sales without any filters) (After I selected "Established" in status slicer, all the numbers turn into negative. Same thing would happen if I selected product market slicer.) Can anyone help me how to apply week over week sales on categories? Thank you in advance!
calculate data for weekdays in future date
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 that shows 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 User 1 users 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 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?
