Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

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

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] );
    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!

Super User
Super User

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?

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 299274256216215253197
Status B 5655938
Status C 72845963887692


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

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors