Forum Discussion

jrescalante's avatar
jrescalante
Advocate I
8 years ago
Solved

Count Rows of Future Calendar Values

Hi everyone, :smileyhappy:

 

This is my first message looking for help. I always get the answers reading other cases in the forum, but in this im really stuck.

 

Im trying to calculate the numbers of saturdays and sundays for this month, but this calendar is until TODAY() May, 16, 2018.

 

Is there a way to count without change the calendar?

 


Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi jrescalante，

     

    By my tests, you could create a measure to get your expected output.

     

    Weekends =
SUMX (
    CALENDAR ( MIN ( 'Table'[Date] ), EOMONTH ( MAX ( 'Table'[Date] ), 0 ) ),
    IF ( WEEKDAY ( [Date], 2 ) IN { 6, 7 }, 1, 0 )
)

     

    Hope this can help you !

     

    Best Regards,

    Cherry

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi jrescalante，

     

    By my tests, you could create a measure to get your expected output.

     

    Weekends =
SUMX (
    CALENDAR ( MIN ( 'Table'[Date] ), EOMONTH ( MAX ( 'Table'[Date] ), 0 ) ),
    IF ( WEEKDAY ( [Date], 2 ) IN { 6, 7 }, 1, 0 )
)

     

    Hope this can help you !

     

    Best Regards,

    Cherry

    • jrescalante's avatar
      jrescalante
      Advocate I
      8 years ago
      v-piga-msft wrote:

      Hi jrescalante，

       

      By my tests, you could create a measure to get your expected output.

       

      Weekends =
SUMX (
    CALENDAR ( MIN ( 'Table'[Date] ), EOMONTH ( MAX ( 'Table'[Date] ), 0 ) ),
    IF ( WEEKDAY ( [Date], 2 ) IN { 6, 7 }, 1, 0 )
)

       

      Hope this can help you !

       

      Best Regards,

      Cherry

       

      Thank you so much! im smiling right now :smileyvery-happy: