Number of working days exc. weekends between two given dates

DAX DAX Calculations
1

Good morning all,

I would like to ask for help regarding my current task.

I need to calculate the difference between start date and actual date of leaving for employees. The number of working days should exclude Saturdays and Sundays.

25_05_23 number of days ( excluded weekends).pbix (78.3 KB)

I have tried several ideas found online and all the measures are in the attached PBI file. Still, the outcome of all of them is incorrect. Can’t navigate the problem here.

Would you please help?

Grateful as always.

Iwona

2

Does this get closer tot he proper figures?

WorkingDaysOnly = 
VAR SlctStartDate = Max('Leavers-NEW'[Start Date])
VAR SlctEndDate = MAX('Leavers-NEW'[Actual date of leaving])
VAR DaysInPeriod = DATESBETWEEN(DIM_TIME_WORKED_HOURS[OP_DATE],SlctStartDate,SlctEndDate)
VAR Result = CALCULATE(COUNTROWS(DIM_TIME_WORKED_HOURS),DaysInPeriod,NOT DIM_TIME_WORKED_HOURS[OP_DAYOFWEEKNO] IN{7,1} )
RETURN Result
3

Hello @Iwona

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you

4

HI @kylie.oconnell

I would like to say a big thank you to you for your time/help/knowledge.

Iwona

1 Like