Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JeroenP
Frequent Visitor

Calendar working days

Hello,

 

I'm pretty much a newby.

 

I would like to make a calendar, where the days of the weekend have the same daynumber as friday.

Saterday and sunday = daynumer friday, monday = friday + 1, tuesday = monday plus 1 etc.

 

Calender  working days.png

 

Awaiting your reply.

 

Kind regards, 

 

Jeroen

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@JeroenP , refer to my blog Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calenda...

Saturday and Sunday have a date of Friday.

View solution in original post

ryan_mayu
Super User
Super User

@JeroenP 

you can create a column

Working days = 
VAR _count=CALCULATE(COUNTROWS('Table 2'),FILTER('Table 2','Table 2'[weekday]=1&&'Table 2'[Date]<=EARLIER('Table 2'[Date])))
REturn if(_count>1,'Table 2'[Calendar days]-_count+1,'Table 2'[Calendar days])

1.PNG

please see the attachment

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@JeroenP 

you can create a column

Working days = 
VAR _count=CALCULATE(COUNTROWS('Table 2'),FILTER('Table 2','Table 2'[weekday]=1&&'Table 2'[Date]<=EARLIER('Table 2'[Date])))
REturn if(_count>1,'Table 2'[Calendar days]-_count+1,'Table 2'[Calendar days])

1.PNG

please see the attachment

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




JeroenP
Frequent Visitor

Thanks for your support.

This is what I was looking for

Jeroen

amitchandak
Super User
Super User

@JeroenP , refer to my blog Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calenda...

Saturday and Sunday have a date of Friday.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.