Next date from day of week number

[Geo_Nelson]

Need to add a calulated column that returns a date based on day of week number from a given date.

Example:

Process Date (given date): Friday 09/09/22

Route Departure Day (day of week number): 2

Need calulation to return: Monday 09/12/22

thanks, geo

[v-rzhou-msft]

Hi @Geo_Nelson ,

I think you can try this code to create a calculated column.

Next date = 'Table'[Process Date] + 'Table'[Route Departure Day] + 1

 Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Geo_Nelson Try:

Departure Date = 
  VAR __Date = MAX('Table'[Process Date])
  VAR __DeptDay = MAX('Table'[Route Departure Day]
  VAR __Table = ADDCOLUMNS(CALENDAR(__Date,__Date+7),"WeekdayNum",WEEKDAY([Date])
RETURN
  MINX(FILTER(__Table,[WeekdayNum] = __DeptDay),[Date])

[Geo_Nelson]

@Greg_Deckler I'm sure I'm doing something wrong on my end. 

[Greg_Deckler · Accepted solution]

@Geo_Nelson Sorry, missed a paren:

Departure Date = 
  VAR __Date = MAX('Table'[Process Date])
  VAR __DeptDay = MAX('Table'[Route Departure Day]
  VAR __Table = ADDCOLUMNS(CALENDAR(__Date,__Date+7),"WeekdayNum",WEEKDAY([Date]) )
RETURN
  MINX(FILTER(__Table,[WeekdayNum] = __DeptDay),[Date])