Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |