Max number of week endings by month

Max Weeks In Month.pbix (117.7 KB)
Date Table Required Output.xlsx (199.7 KB)

I have a Dates Table where I have a weekending date, what I would like to do is to capture the max number of week ending dates for each month in field called “Max Weeks Per Month”. Ideally, I want to do this using M Code.
I have attached my PBIX & an Excel file highlighting the desired output.
Is this possible to do using M code or would I need to do it in DAX?

Long term I want to be able to use this field to determine whether whole months or single weekending dates have been selected and use that to output a message for the user as to what has been selected.
The output message to group whole months and list single week ending dates.

Any help would be really appreciated.

Max Weeks In Month.pbix (122.0 KB)

1 Like

This is amazing thank you so much it has made my day…so quick! I had part of it correct but using the List function blew my Date table columns away so after that I was stumped!

The second part is:
If someone selects multiple non-consecutive months, is it possible to use a measure to determine what these months are so that I can output that message using a date format of MMM-YYYY?

Please let me know if this is doable. Thanks.

@Kazza Share an example of that with Excel.

@AntrikshSharma Please find the requested example attached.
Output v2.xlsx (184.8 KB)

Hi @Kazza,

We noticed that your inquiry was left unsolved for quite some time now.
Looks like your inquiry was out of the experts and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!

In light of this, we will be closing this thread, but we invite you to start a new thread with updated details so that our experts can better assist you.

Thank you for being a part of our community, and we hope you find the help you need.

This video might give you some pointers:

1 Like

Apologies for my very tardy reply! The YouTube video certainly gives me a few ideas. Thanks so much!

1 Like