Workdays in current Month

Hi EmWy24 ,
It's not complicated to realize this I'll try to use the following DAX in a newly created date table to help you find the number of days worked in each month.

Workdays = 
CALCULATE(
    COUNTROWS('DateTable'),
    'DateTable'[Date] >= DATE(YEAR(TODAY()), MONTH(TODAY()), 1),
    'DateTable'[Date] <= EOMONTH(TODAY(), 0),
    WEEKDAY('DateTable'[Date], 2) <= 5
)

Below is the community Blog on how to find the number of working days, one of the real Power query to filter, I hope to help your question, if you have further questions, you can feel free to contact me, I will be the first time to reply when I receive your message!

Calculate the working days between two dates exclu... - Microsoft Fabric Community

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.