3rd Wednesday of Previous month , Current Month and Next month

[Anonymous]

Hi Team,

I would need some help on calculating dates for following : Based on Current date , I would like to know the dates of 3rd week Wednesdays date of Previous Month , 3rd week Wednesdays date of Current Month and 3rd week Wednesdays date of Next month.

Kindly assist .

G Venkatesh

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

I modified my answer.

Please refer to my .pbix file.

Best regards,
Lionel Chen

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

[Greg_Deckler]

@Anonymous - Here is an example that might work:

3rd Wednesday This Month =
  VAR __Date = MAX('Table'[Date])
  VAR __Calendar = CALENDAR( DATE(YEAR(__Date),MONTH(__Date),1), EOMONTH(__Date,0) )
  VAR __Calendar1 = FILTER(__Calendar, WEEKDAY([Date]) = 4)
  VAR __Calendar2 = ADDCOLUMNS(__Calendar,"Count",COUNTX(FILTER(__Calendar1,[Date]<=EARLIER([Date]),[Date])
RETURN
  MAXX(FILTER(__Calendar2,[Count]=3),[Date])

Something along those lines.