Number of Days between two days excluding weekends

[erezbenmoshe]

Hello,

I found a lot of suggestions about the subject and used the following:

IfWorkDay = SWITCH('Calendar'[DayOFWeekNum],
6,0,
7,0,
1)

Broad to Exc =

CALCULATE(SUM('Calendar'[IfWorkDay]),

                        DATESBETWEEN('Calendar'[Date],DeliveriesStats[BroadCast Date],DeliveriesStats[Excecution Date]))

The problem I have is that the result of the calculation for same day delivery on a weekday is 1 where it should be 0.

Please help ...

Thanks,

Erez

[v-cherch-msft]

Hi @erezbenmoshe

Your calculated column “Broad to Exc” seems correct. It’s better to share your file for us. Also, here is the reference for you to try another way to calculate workdays.

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

Regards,

Cherie