Changing First working day of the week

[dcg38524]

Hello,

Our team reporting week starts on Thursday ending the following Wednesday, I am struggling with attempting to achieving this task using DAX. 

I found the formula below and not sure if it will work in our situation but have not been very successful in modifying it to reflect our current requirements.

Thank you

First Working Day =

VAR TodaysDate = TODAY()

VAR Calendar1 = CALENDAR(DATE(YEAR(TodaysDate),1,1),DATE(YEAR(TodaysDate),12,31))

VAR Calendar2 = ADDCOLUMNS(Calendar1,"WeekNum1",WEEKNUM([Date]))

VAR Calendar3 = ADDCOLUMNS(Calendar2,"WeekDay1",WEEKDAY([Date],2))

VAR TodaysWeekNum = WEEKNUM(TodaysDate)

VAR Calendar4 = FILTER(Calendar3,[WeekNum1]=TodaysWeekNum&&[WeekDay1]<6)

VAR FirstWorkingDay = MINX(Calendar4,[Date])

RETURN FORMAT(FirstWorkingDay,"mm/dd/yyyy")

[PaulDBrown · Accepted solution]

@dcg38524 

I’m not entirely sure what your expected outcome is. It reads like you want the date of next Thursday based on today’s date.

If so, this thread (which is asking for help to calculate the date for next wednesday based on today’s date) might help:

https://community.powerbi.com/t5/Desktop/Return-date-of-next-Wednesday-in-a-tile/m-p/847447#M406761