Count Rows of Future Calendar Values

[jrescalante]

Hi everyone, 

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?

[v-piga-msft · Accepted solution]

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]

---

@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