Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Align Day and Date according to 1st Business Day of Each Month


I am stuck with the following problem.

I am trying to align daily app login stats according to the week of the login.


Example : 

Monday 3 Feb | Week 1 of February | 7 Login 

    would need to be compared to 

Monday 2 March | Week 1 of March | 5 Logins


And then all subsequent days would match according to the day of the week ie Tuesday 4 Feb vs Tuesday 3 March.


I am able to create a measure and/or column to identify the week no, the week no of the month, the 1st working day of the month, 1st Sunday or Monday of the month etc, but cannot incorporate this into a visual that matched accordingly.


Any guidance would be appreciated. 


Super User IV
Super User IV

Re: Align Day and Date according to 1st Business Day of Each Month

Create a working day in calendar

Work Day


Then have new column like

Work day No = countx(filter(date,Date[Month year] = earlier(Date[Month year]) &&  Date[Date] <= earlier(Date[Date])),date[Work day])


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Frequent Visitor

Re: Align Day and Date according to 1st Business Day of Each Month

Thanks, appreciate the quick response. 


In your example :

What does [Work day] column hold ?

Month year is just a column : FORMAT('Date'[Date],"mmm yyyy") ?


I use the following measure to get the 1st Monday of the each month


Is 1st Monday =
VAR a = MIN('Date'[Date])
YEAR('Date'[Date]) = YEAR(a) &&
MONTH('Date'[Date]) = MONTH(a) &&
DAY([Date]) > 0 &&
DAY([Date]) < 8 &&
WEEKDAY([Date],2) = 1)


I can't upload file unfortunately as our network access does not allow for it

Community Support
Community Support

Re: Align Day and Date according to 1st Business Day of Each Month

@eishman ,


Could you please paste some sample data and clarify more details about the expected result?



Jimmy Tao

Helpful resources

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors