Workday in month as calculated column

[KVPro]

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

[Surya9]

@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

[johnt75 · Accepted solution]

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]

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