Forum Discussion

KVPro's avatar
KVPro
Frequent Visitor
4 years ago
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.2...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    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]) )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

KVPro 
You can create the calulated Column

Day = 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