DAX for Full Weeks Only (Sunday - Saturday) in Previous Month

[mstan]

Hi Everyone,

I am looking for a way to capture data only from days in the (1)previous month which are (2)part of a full Sunday - Saturday week.

For example, I would only want to see data from Janury 1st - 28th of 2023, since 29-31 are not part of a full calendar week in January.  Additionally, if the 1st had fallen on any date other than Sunday, I would not want to see that or any dates prior to the first Sunday of the month.

My date table should have everything I need through a combination of Year/Month/WeekNum/WeekdayName/WeekdayNumber/WeekStartDate/WeekEndDate, etc... but I'm having trouble putting it all together.

I found this solution, but it appears to be rolling days in the previous month into the days in week count:

week_Max =
IF (
    data[Year_Week] = MAX ( data[Year_Week] );
    "week_Max";
    IF ( data[Year_Week] = MAX ( data[Year_Week-1] ); "week_Max-1" )

 If anyone has a solution they can share, I would be greatly appreciative!

[FreemanZ]

hi @mstan 

What do you going to do with the captured days?

What do you going to do with imcomplete days, like 29-31 Jan and 1-4 Feb?

[mstan]

Thanks for the response!

I have to recreate a matrix with statuses, and the average of statuses received for each workday in the previous month, which would be the count of status divided by number of weeks (or count of  weekday) in the month:

	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
Status A	299	274	256	216	215	253	197
Status B	5	6	5	5	9	3	8
Status C	72	84	59	63	88	76	92

at the request of my partners, the incomplete days should be omitted from the data completely.