Calculated Formula to count records within own month

[Anonymous]

I'm trying to count the number of records within a month and put it in a calculated column so I can use it in another column based calculation.

Basically, I need to get the count like this:

 

[Vvelarde · Accepted solution]

@Anonymous

Hello, try with this in a calculated column

Recordsinthemonth = 
VAR MonthinRow=MONTH(Table1[Date])
RETURN
COUNTROWS(FILTER(All(Table1),MONTH(Table1[Date])=MonthinRow))

Regards

Victor

Lima - Peru

[Anonymous]

That worked so easily. I just started learning DAX and all the solutions I could think of were within its own bounds, ironically, like my problem here.

[nickchobotar]

Hello,
Since you just started learning DAX it's a good idea to be able to think about different solutions to your problems. In case if you are in that pre-variables DAX environment  SSAS 2012 or Excel < 2016 here is the solution to question with EARLIER()

Count =
COUNTROWS(
    FILTER(
        Table1,
        MONTH(Table1[Date]) = MONTH(EARLIER(Table1[Date]))
    )
)

Nick -