How to exclude Saturday and Sunday date in Burndown Chart

[mprakash]

Hi All,

I have created a burn down chart which i took from custom market place. 

I have created planned hours for that, and will be comparing with actual hours to complete it.

Porvided below the formula for Planned hours to complete.

Planned Hours =

Var SprintStartDate = CALCULATE(FIRSTDATE('Calendar'[Date]),ALLSELECTED(Sheet1))

Var DaysSinceStart = DATEDIFF(SprintStartDate,Max('Calendar'[Date]),DAY)

Var BeginningStart = CALCULATE(MAX(Sheet1[Remaining Hours to complete]),ALLSELECTED(Sheet1))

Var SprintLength = 9

Return

IF(MAX('Calendar'[Date])>= SprintStartDate && MAX('Calendar'[Date])<= SprintStartDate+SprintLength,

BeginningStart - DaysSinceStart * (BeginningStart/SprintLength),BLANK())

Now my concern is how to exclude the weekend date in this formula i.e., i have to exclude saturday and sunday, because generally we won't work in weekend.

Once we removed then the Planned hours should be a straight line.

Please help me on this. Thank in advance.

Regards,

Prakash M

[amitchandak · Accepted solution]

@mprakash , you can add filter for weekday('Calendar'[Date],2) <6