Count of Items per Month

[Anonymous]

This seems like it should be simple but I can't seem to figure it out nor find the solution within the community. I have a Date table I created and I want to count the number of items created within each month, for example 10 items in Jan, 15 in Feb, etc. I placed the month column on my X-axis and the Created On column on my Y-axis but what I get in return is the total number of items showing up in each month. 

[marcelsmaglhaes · Accepted solution]

Hey @Anonymous ,

You can try use COUNTROWS function in a DAX measure. See the image bellow

[Cmatt67]

hi, can you confirm the actual Dax you used? Im trying to use countrows and it wont work.

[marcelsmaglhaes]

Hi @Cmatt67 

What do you want to do exactly?

[Anonymous]

Thank you, Marcel. I was using the formula incorrectly but it is working now using Countrows.