Forum Discussion

bilalkhokar73's avatar
bilalkhokar73
Helper IV
4 years ago
Solved

Weekend Count till the date

This measure is giving me no of weekend in current month  Which is = 4 , Now today is 22 June , I want no. of weekend till date which should be 3  WeekendCOunt = countx(FILTER(dateA,date[IsWeekend...
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    bilalkhokar73 I added another condition, please try:

    COUNTX (
    FILTER (
        dateA,
        date[IsWeekend] = TRUE ()
            && EOMONTH ( dateA[Date], 0 ) = EOMONTH ( TODAY (), 0 )
            	&& dateA[Date] <= TODAY ()
    ),
    dateA[Date]
)