Forum Discussion

gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Count Weekends

I want to count the weekend (Fri & Sat) as of today.  How can I add "as of today" to the below measure so I can get the desired result count 1?   _weekendcountasoftoday = CALCULATE(     COUNTROWS...
Need Help
Show and Tell
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, gauravnarchal 

     

    You can try the following methods.

    _weekendcountasoftoday = 
CALCULATE (
    COUNTROWS ( 'Calendar' ),
    FILTER (
        ALL ( 'Calendar' ),
        [WeekdayWeekend] = "Weekend"
            && [Date] <= TODAY ()
            && [Monthyear] = SELECTEDVALUE ( 'Calendar'[Monthyear] )
    )
)

    The day I replied to you is April 5, and the weekend count should be 2.

    When I replace today with April 2nd as you asked, I get the result you were expecting before with the number 1.

    This should be your desired outcome.

     

    Best Regards,

    Community Support Team _Charlotte

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

gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
4 years ago

Thanks Ashish_Mathur  - It gives me the count of the weekend results as YTD. How can I get the result weekend result for MTD as of today?

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

What do you mean by MTD as of today and how can the answer be 26?