calculate count of specific day of week

[Tprogrammer]

hi, i would like to know how to calculate count of an specific day of week.

Ex:   (2018-01-01 to 2018-12-31 , "Monday")

result: 52.

[jthomson]

Try looking into the WEEKDAY function - say you've got a calendar table that runs through 2018, the DAX function calculate(countrows[DateTable],weekday([datefield])=2) should return what you're looking for

[Tprogrammer]

i need the count between two dates.

[Zubair_Muhammad · Accepted solution]

@Tprogrammer

Try this

CountMonday =
VAR StartDate =
    DATE ( 2018, 1, 1 )
VAR EndDate =
    DATE ( 2018, 12, 31 )
VAR Temp =
    ADDCOLUMNS (
        GENERATESERIES ( StartDate, EndDate ),
        "WeekDay", WEEKDAY ( [Value], 2 )
    )
RETURN
    COUNTROWS ( FILTER ( Temp, [WeekDay] = 1 ) )

[NTH_Tony]

Hi,

Would it be possible to amend the solution below to return 0 if there are no Mondays within the date range provided?

Currently it generates an error 'Calculation error in measure, The arguments in GenerateSeries function cannot be blank'

I am trying to use it to record which days were covered by an absence period, but as these periods can be less than a week, there isnt necessarily a Monday in the date range I am providing.

I tried changing the final line to :-

if(COUNTROWS ( FILTER(Temp,[Weekday] = 1)) = BLANK(),BLANK(),(COUNTROWS(FILTER(temp,[Weekday] = 1))

However this clearly isnt correct as it doesnt work,

Any assistance would be really appreciated.

Thanks