Forum Discussion

jrescalante's avatar
jrescalante
Icon for Advocate I rankAdvocate 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 number...
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

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident 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
    Icon for Advocate I rankAdvocate 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: