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]) )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
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]) )
  • KVPro's avatar
    KVPro
    Frequent Visitor
    4 years ago

    OMGGG, I really really thank you. I've been struggling with this for almost a week