count # of complaints group by created month and year using DAX commands

[nora_cy_lee]

I want to count # of complaints group by created month and year using DAX commands.  Complaint # is unique.

Sample data – ComplaintTable:

ComplaintNum       CreatedDate

CO1                        20181102

CO2                        20181104

CO3                        20181228

CO4                        20190115

CO5                        20190220

CO6                        20190229

CO7                        20190305

CO8                        20190407

Results:

Created Date     Total

2018-11             2

2018-12             1

2019-01             1

2019-02             2

2019-03             1

2019-04             1

I built this DAX column but it seems not working:

TotalComplaintCreated =

COUNTROWS (

  FILTER (

    ComplaintTable,

    ComplaintTable[ComplaintNum] = EARLIER(ComplaintTable[ComplaintNum])

      && MONTH (ComplaintTable[CreatedDate]) = MONTH(EARLIER(ComplaintTable[CreatedDate]))

      && YEAR (ComplaintTable[CreatedDate]) = YEAR(EARLIER(ComplaintTable[CreatedDate]))

))

Does anyone know why?  Thanks.

[parry2k]

@nora_cy_lee convert your created dte column in date data type instead of number/text in current format and then it is super easy.

[nora_cy_lee]

I can confirm the date is 'm/d/yyyy'.  I believe I found the problem and it seems working now.  Thanks.

[nora_cy_lee]

CreatedDate is already in date format, yyyymmdd.

[parry2k]

@nora_cy_lee you see it as date type but if you go on modelling tab, select your created date column, what you see its' data type?