How to show the network days between two dates if those two dates are weekend dates

[Anonymous]

Hi Community,

I have two date columns which named as End date and Fy Year end.. Now i want to find out network days between those two days for that i used this measure which is giving proper count. See below:

NetWorkDaysEND =

VAR Calendar1 = CALENDAR(MIN('Query1'[END]),MAX('Query1'[FYEND]))

VAR Calendar2 = ADDCOLUMNS(Calendar1,"WeekDay",WEEKDAY([Date],2))

RETURN

COUNTX(FILTER(Calendar2,[WeekDay]<=5),[Date])

But I am facing one issue here, In my data Couple of End dates and FYEnd dates are same and those dates are Weekend dates. For those dates i am getting blank instead of blank i want 0.

What should i modify in my measure

Here is my screenshot of that data

Please help me out from this

Thanks in advance

B V S Sudhakar

[gooranga1 · Accepted solution]

Hi @Anonymous 

You could try this amendment to force a zero where blank.

[gooranga1 · Accepted solution]

Hi @Anonymous 

You could try this amendment to force a zero where blank.

[Anonymous · Accepted solution]

Hi @gooranga1,

Thank you for your answer.

But for my case i can't write like that so i wrote like this

NetWorkDaysEND =

VAR Calendar1 = CALENDAR(MIN('Query1'[END]),MAX('Query1'[FYEND]))

VAR Calendar2 = ADDCOLUMNS(Calendar1,"WeekDay",WEEKDAY([Date],2))

RETURN

COUNTX(FILTER(Calendar2,[WeekDay]<=7),[Date])- COUNTX(FILTER(Calendar2,[WeekDay]>=6),[Date])

This was worked for me