cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

I need to find how many days between Submitted date to the Working Days

Dear All ,

Requiremnet:i Have column as Submitted date i need to find Work day time for that Particular Month ,Suppose 16th Dec then it has to WD+9 as we have to exclude Sat,sun and Holidays,Please find the below Screenshots:

 

Capture1.JPGCapture2.JPG

 

Thanks In Advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: I need to find how many days between Submitted date to the Working Days

Hi @ younis,

According to your description,  you have evaluated each date is a working day or a non-working day. Now you can use the below calculated column to calculate how many working days there are between the Submitted Date and the Workdays date:

Calworkdays.JPG

 

 

 

 
The specific formula as follow:

Calworkdays = CALCULATE( COUNTROWS('Calendar table'),

                             FILTER('Calendar table', 'Calendar table'[Workday/Not A workday]="Working Day"),

                           DATESBETWEEN('Calendar table'[Date],'Workday table'[Workdays],'Workday table'[Submitted Date])

                          )

 

Best Regards

Rena

View solution in original post

4 REPLIES 4
Highlighted
Helper III
Helper III

Re: I need to find how many days between Submitted date to the Working Days

If It is 25th Dec then WD-5/WD+17  as i have to exclude  weekends and 25th Dec is Holiday

 

Highlighted
Super User IV
Super User IV

Re: I need to find how many days between Submitted date to the Working Days

Highlighted
Helper III
Helper III

Re: I need to find how many days between Submitted date to the Working Days

Hi @amitchandak  ,

 

In my Case i have already created a table and column which has only working Days,
now supposed submitted date is 6th Jan 2019 now i have to count Workday column till it matches with Submitted date..
Eg:

Submitted Date      Workdays
2019/01/06              2019/01/02   

                                 2019/01/03

                                 2019/01/06

now Ans should be like WD+3

 

Conclusion Count till You MATCH

 

Thanks In Advance.

 

Highlighted
Microsoft
Microsoft

Re: I need to find how many days between Submitted date to the Working Days

Hi @ younis,

According to your description,  you have evaluated each date is a working day or a non-working day. Now you can use the below calculated column to calculate how many working days there are between the Submitted Date and the Workdays date:

Calworkdays.JPG

 

 

 

 
The specific formula as follow:

Calworkdays = CALCULATE( COUNTROWS('Calendar table'),

                             FILTER('Calendar table', 'Calendar table'[Workday/Not A workday]="Working Day"),

                           DATESBETWEEN('Calendar table'[Date],'Workday table'[Workdays],'Workday table'[Submitted Date])

                          )

 

Best Regards

Rena

View solution in original post

Helpful resources

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

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

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

Top Solution Authors
Top Kudoed Authors