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

Need to combine Friday/Saturday and Sunday/Monday in my "workday" column



Our reporting team looks at work days a little differently than what I am used to. They like to rollover Saturday's numbers into Friday and Sundays numbers into Monday. I started creating a "WorkdayNumber" column in my date reference table but I can't figure out how to include weekends in the way I just described. For example, The first 2 blanks in the "WorkdayNumber" column should read 3 and 4 since Friday/Saturday are being grouped together and Sunday/Monday are. 



Here is a zoom in of the "WorkdayNumber" column and the values that should fill in the blanks.




Any help would be appreciated!

Super User
Super User

@Wantanewhouse , Group Friday, Saturday, and Sunday into the month


Create a new column in your data table and join it date of the date Table


New date  = If( weekday('Table'[date],2) >=5 , 'Table'[Date]+ 7-1*WEEKDAY('Table'[Date],2) +1  , 'Table'[Date])

Features || Datamarts: || Field Parameters :
Learn Power BI P&L Statement || Time Intelligence Decoded : ||
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

@amitchandak Thank you for the response! I was able to create the new date field in my data table and join it to the main date field in my date reference table. Everything looks good from a date perspective but now I need to do a year over year work day comparison. Right now when I compare days, things are understandably disjointed. How can I cleanly compare workdays now that I have the new date field?By day.png


Helpful resources

November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.