Count the number of days and weekends

[gauravnarchal]

How can I count the number of days and weekends as of today in a month?

Saturday & Sunday are considered the weekend.

[Anonymous · Accepted solution]

Hi @gauravnarchal ,

I have created a Calendar table for test, and on my side, today is 2022/4/5.

Please create measures:

Working days = CALCULATE( COUNTROWS(FILTER('Calendar',[Date]<=TODAY())) ,FILTER('Calendar', WEEKDAY([Date],2) in {1,2,3,4,5}))

Weekends = CALCULATE( COUNTROWS(FILTER('Calendar',[Date]<=TODAY())) ,FILTER('Calendar', WEEKDAY([Date],2) in {6,7}))

Output:

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

[VijayP]

@gauravnarchal 

Try this

CALCULATE(Countrows(datesdim), all(datesdim), format(datedim[date],"DDD") = "Sat" && format(datedim[date],"DDD") = "Sun"))

[gauravnarchal]

Hi @VijayP - I need to count the number of days and weekends as of today of a month?

The answer provided is not working as I am not getting the desired result.