Exclude week-ends

[KatkaS]

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!

[v-yiruan-msft]

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

[KatkaS]

Thank you so much to all of you!!!!

[v-yiruan-msft · Accepted solution]

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

[Greg_Deckler]

@KatkaS - Net Work Days - https://community.powerbi.com/t5/Quick-Measures-Gallery/Net-Work-Days/m-p/367362#M109

[amitchandak]

@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