Forum Discussion
Solved
Outstanding Days Calculation excluding weekends and Bank holidays
Hi,
I have this caluclation below, which almost does what I need. I now need to exclude weekends and bank holidays can anyone help me with this please?
Days Outstanding =
IF(
ISBLANK([EndDate])
,DATEDIFF([StartDate],TODAY(),DAY)
,BLANK()
)
Hello lennox25 ,
then you need to use the dax function " networkDays"
check it out
https://dax.guide/networkdays/https://learn.microsoft.com/en-us/dax/networkdays-function-dax
2 Replies
Hello lennox25 ,
then you need to use the dax function " networkDays"
check it out
https://dax.guide/networkdays/https://learn.microsoft.com/en-us/dax/networkdays-function-dax
Hi Idrissshatila thanks, thats fine, but how to I incorporate into my calculation?
