How to count the number of Mondays in a date range

[amulder]

I've been searching and searching but I can't seem to find the syntax for a measure that will allow me to count the number of Mondays within a date range. The date range will be selected through a slicer on the same page.

What is the DAX syntax in order to do this?

Thanks!

 

[VBA Geek]

You could add a Calculated Column displaying the weekday

= WEEKDAY( Dates[Date] )

and then your measure

= CALCULATE( COUNTROWS( Dates ), Dates[WeekDay] = 2 )

 

[amulder]

[FONT=&quot]I need the day of the week to adjust automatically when I add it to my matrix but only be filtered by the column not the row. Right now I'm just using a simple COUNT('Date'[DOW) which works on its own, however in my matrix I have a column titled HourBlock that breaks my count of records (Number) down by hour. Since not every hour within the month filter has records the DOW_COUNT gets filtered accordingly. I don't want it to. I essentially want the values that I see in the small matrix beside the big one which has the official counts of the days of the week.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]

[/FONT]

 

[VBA Geek]

Are you looking to remove the filter being applied by the HourBlock Column? Have you tried using ALL to remove the filter from within CALCULATE ?