Hi, I would like to find the next third Wednesday given a date? Can it be done in Power BI to calculate the next third Wednesday when given a date. Example: if I am given 31 May 2020, the next third Wednesday it should give is 17 Jun 2020. If I am given 1 May 2020, it will give me 20 May 2020.

@jonatong We can call this the month end date on the third Wednesday of the Month. This means any date in the current month greater than the 3rd Wednesday of the Month rolls over to the next Month 3rd Wednesday of the Month. [image] With M Code, query editor, I will add 3 custom columns in the d…

Find the next third Wednesday of a date?

Power Query

Melissa May 31, 2020, 10:31am 2

A similar question has been asked before, please review this post to see if that helps you to resolve it.

Should you need any further assistance, just provide a sample PBIX file.
Thanks!

1 Like