cancel
Showing results for
Did you mean:
Highlighted Helper I

## Calculated Formula to count records within own month

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: 1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted Community Champion

## Re: Calculated Formula to count records within own month

@fmx

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

Lima - Peru
3 REPLIES 3
Highlighted Community Champion

## Re: Calculated Formula to count records within own month

@fmx

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

Lima - Peru
Highlighted Helper I

## Re: Calculated Formula to count records within own month

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.

Highlighted Continued Contributor

## Re: Calculated Formula to count records within own month

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 -  