Forum Discussion

bilalkhokar73's avatar
bilalkhokar73
Icon for Helper IV rankHelper 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]=TRUE() && eomonth(dateA[Date],0) = eomonth(today(),0)),dateA[Date])

This measure is giving me no of weekend in current month , Now today is 22 JUne , i want no of weekend till date
Answer will be 3

how to make it through

v-yanjiang-msft 

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]
)

2 Replies

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    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]
)