Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Solved! Go to Solution.
I have created 2 Calculated columns in Date table
Regards,
Prime
Thanks for your suggestion.
But unfortunately this is a date table and created using the CALENDERAUTO() as shown in below syntax
I have created a date table in PQ, just wondering how do I account bank holidays into PQ?
I have created 2 Calculated columns in Date table
Regards,
Prime
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |