Hi,
I am trying to calculate the Working days remaining for each month,
I have created a column to calculate if each day is Working day or not, But my requirement is if it is weekend or a non working day then it should show the previous days remaining working days
I have created the Rank for Working Day in Month by using the following DAX
Rank For Working Day in Month =
// Calculates the Working Day Rank by YearMonth
VAR AllDates = Dates[Date]
VAR YearMon = Dates[YearMon]
RETURN
CALCULATE (
RANK.EQ ( AllDates, Dates[Date], DESC ),
FILTER ( ALL( Dates ), AND(Dates[WorkingDay] = "Y", Dates[YearMon] = YearMon)
))
| Date | WorkingDay | Rank For Working Day in Month |
| Thursday, 1 August 2019 | Y | 21 |
| Friday, 2 August 2019 | Y | 20 |
| Saturday, 3 August 2019 | N | |
| Sunday, 4 August 2019 | N | |
| Monday, 5 August 2019 | Y | 19 |
| Tuesday, 6 August 2019 | Y | 18 |
| Wednesday, 7 August 2019 | Y | 17 |
| Thursday, 8 August 2019 | Y | 16 |
| Friday, 9 August 2019 | Y | 15 |
| Saturday, 10 August 2019 | N | |
| Sunday, 11 August 2019 | N | |
| Monday, 12 August 2019 | Y | 14 |
| Tuesday, 13 August 2019 | Y | 13 |
| Wednesday, 14 August 2019 | Y | 12 |
| Thursday, 15 August 2019 | Y | 11 |
| Friday, 16 August 2019 | Y | 10 |
| Saturday, 17 August 2019 | N | |
| Sunday, 18 August 2019 | N | |
| Monday, 19 August 2019 | Y | 9 |
| Tuesday, 20 August 2019 | Y | 8 |
| Wednesday, 21 August 2019 | Y | 7 |
| Thursday, 22 August 2019 | Y | 6 |
| Friday, 23 August 2019 | Y | 5 |
| Saturday, 24 August 2019 | N | |
| Sunday, 25 August 2019 | N | |
| Monday, 26 August 2019 | N | |
| Tuesday, 27 August 2019 | Y | 4 |
| Wednesday, 28 August 2019 | Y | 3 |
| Thursday, 29 August 2019 | Y | 2 |
| Friday, 30 August 2019 | Y | 1 |
| Saturday, 31 August 2019 | N | |
This is what I have achieved so for but, as you can see there are blanks for example on the 3rd and 4th I need to get 20.
Could anybody please help me in this regard.
Thanks,
Prime
