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.

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

gauravnarchal 

maybe try

CALCULATE(

    COUNTROWS('Calendar'), all('Calendar'), 'Calendar'[WeekdayWeekend] = "Weekend" && ‘Calendar'[Date]<=today() )

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

Hi ryan_mayu  - I am not getting the result using this measure. When I select the month April’22 in the slicer, I am getting the result as 861 which is YTD instead of 1 as this month (April 22) today is the first weekend.