Forum Discussion
Solved
Workday in month as calculated column
Hi
I have data as here:
| Date | DayName | Expected Workday |
| 01.04.2022 | Friday | 1 |
| 02.04.2022 | Saturday | 1 |
| 03.04.2022 | Sunday | 1 |
| 04.04.2022 | Monday | 2 |
| 05.04.2022 | Tuesday | 3 |
| 06.04.2022 | Wednesday | 4 |
| 07.04.2022 | Thursday | 5 |
| 08.04.2022 | Friday | 6 |
| 09.04.2022 | Saturday | 6 |
| 10.04.2022 | Sunday | 6 |
How to calculate workday as above? It must be calculatef column for each months based on date. Saturday and Sunday doesn't working days, so I want to get earlier value (for Friday).
Please help me
Add a new column to your date table, Is Working Day, which returns 1 for Monday-Friday then you can add a new column to your table like
Working day in month = CALCULATE( SUM('Date'[Is working day]), DATESMTD('Date'[Date]) )
3 Replies
johnt75Super User
Add a new column to your date table, Is Working Day, which returns 1 for Monday-Friday then you can add a new column to your table like
Working day in month = CALCULATE( SUM('Date'[Is working day]), DATESMTD('Date'[Date]) )OMGGG, I really really thank you. I've been struggling with this for almost a week
KVPro
You can create the calulated ColumnDay = WEEKDAY('Calendar'[Date],2) -- Day start from monday and end on sunday
and while calculating apply filter day < 6
I think this will work. Pls ask if you need any help
