Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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 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
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |