Power Query nth day of the Month Based on date and Day of Week

**alo2279** · 04-02-2025, 02:41 PM

In power Query I need to return what occurrence of the the month each Day is. I'm given the Date and the Day "dddd". Now I need to know what occurrence of the day each date is.
For ex: 10-9-23 was a Monday. I need to return that it was the 2 Monday in Oct.

Please see example sheet. I have the blue columns, I need to know how to get to the orange column results.

I need to stay in power query for this.

Thanks for any help.

Date Day nth Day of Month
10/9/2023 Monday 2
10/10/2023 Tuesday 2
10/23/2023 Monday 4

**MarvinP** · 04-02-2025, 03:57 PM

Hi alo,

Isn't there a function in PQ that is Date.DayOfWeekName()?? Is that what you want?
I also see a Date.DayOfWeek(). https://learn.microsoft.com/en-us/po...date-dayofweek

Look at https://learn.microsoft.com/en-us/po...date-functions for lots more..

**alo2279** · 04-04-2025, 02:25 PM

THank you

**JeteMc** · 04-05-2025, 12:27 PM

This proposal is based on the linked video tutorial: https://www.youtube.com/watch?v=kjOmNPoVDYs&t=3s
The original table of all dates in October of 2023 is in column A of Sheet 2.
The code used to produce the table in columns C:E is:

Please Login or Register  to view this content.

I imagine that someone can give you a more efficient code.
Let us know if you have any questions.

**Czeslaw** · 04-06-2025, 08:10 AM

Power Query

l

Please Login or Register  to view this content.

Power Query nth day of the Month Based on date and Day of Week

LinkBack

Thread Tools

Rate This Thread

Display

Power Query nth day of the Month Based on date and Day of Week

Re: Power Query nth day of the Month Based on date and Day of Week

Re: Power Query nth day of the Month Based on date and Day of Week

Re: Power Query nth day of the Month Based on date and Day of Week

Re: Power Query nth day of the Month Based on date and Day of Week

Thread Information

Users Browsing this Thread

Similar Threads

Power Query website - based on date input

How to remove duplicate rows in Power Query based on date conditions

Power Query: Look up a Date Between Month Start and End Columns, Return Value

finding a specific date based on the day of the week and the day of the month

[SOLVED] Set a date based on week of the month

Returning Week # per Month based on Date

[SOLVED] How do I generate a new sheet based on date/week/month?

Bookmarks

Bookmarks

Posting Permissions