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

[Anonymous]

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:

Thanks In Advance.

[Anonymous]

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

[amitchandak]

Refer

https://community.powerbi.com/t5/Desktop/Number-of-working-days/td-p/22842

https://poszytek.eu/en/microsoft-en/office-365-en/powerbi-en/powerbi-datediff-only-working-days-hour...

https://www.reddit.com/r/PowerBI/comments/93vxcl/how_to_make_power_bi_only_count_working_days/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

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.

[v-yiruan-msft · Accepted solution]

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:

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