cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Wantanewhouse
Frequent Visitor

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

Hello, 

 

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. 

 

Workday.PNG

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

 

 

Workday2.png

Any help would be appreciated!

2 REPLIES 2
amitchandak
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: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
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

Announcements
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.