Forum Discussion
Exclude week-ends
Hello,
I have a calculated column as per below measure ( Job Req open time in days - it calculates how many days a requisiton is open).
I would need to exclude week-ends out of this.
Could you please help how?
Thank you!
Hi KatkaS ,
First, please create a Date dimension table. Then update the formula of calculated column "Job Req open time in days" as below to exclude weekends:
Job Req open time in days = IF ( 'HRLink Recruitment Report'[Time from request to hire] > 0, 'HRLink Recruitment Report'[Time from request to hire], CALCULATE ( COUNTROWS ( 'Date' ), FILTER ( 'Date', WEEKDAY ( 'Date'[Date], 2 ) < 6 ), DATESBETWEEN ( 'Date'[Date], 'HRLink Recruitment Report'[Date Created], TODAY () ) ) )Best Regards
Rena
5 Replies
KatkaS , for the work day calculation. You might need help from Date table.
Refer to my file on the second page. There is an example of date diff and workday diff
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0
Hi KatkaS ,
First, please create a Date dimension table. Then update the formula of calculated column "Job Req open time in days" as below to exclude weekends:
Job Req open time in days = IF ( 'HRLink Recruitment Report'[Time from request to hire] > 0, 'HRLink Recruitment Report'[Time from request to hire], CALCULATE ( COUNTROWS ( 'Date' ), FILTER ( 'Date', WEEKDAY ( 'Date'[Date], 2 ) < 6 ), DATESBETWEEN ( 'Date'[Date], 'HRLink Recruitment Report'[Date Created], TODAY () ) ) )Best Regards
Rena
Hi KatkaS ,
Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.
Best Regards
Rena
Thank you so much to all of you!!!!
