Forum Discussion

KatkaS's avatar
KatkaS
Icon for Post Patron rankPost Patron
6 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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