Hi,
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.
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?
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.
