Forum Discussion
Solved
Please help!!! Outstanding Days Calculation excluding weekends and Bank holidays
Hi,
I have this calculated column below, which almost does what I need. Currently it give me total days outstanding. I now need to exclude weekends and bank holidays can anyone help me with this please? I have network days - just need to know how to incorporate it into the calculation.
Days Outstanding =
IF(
ISBLANK([EndDate])
,DATEDIFF([StartDate],TODAY(),DAY)
,BLANK()
)
Hi lennox25
There is a NetWorkdays function : https://learn.microsoft.com/en-us/dax/networkdays-function-dax
Days Outstanding =IF(ISBLANK([EndDate]),Networkdays([StartDate],TODAY(),1, Values(banktable[bankholidaydates])),BLANK())
2 Replies
Hi lennox25
There is a NetWorkdays function : https://learn.microsoft.com/en-us/dax/networkdays-function-dax
Days Outstanding =IF(ISBLANK([EndDate]),Networkdays([StartDate],TODAY(),1, Values(banktable[bankholidaydates])),BLANK())Perfect SamWiseOwl you are awesome!
