Count dates within months

[Davebryant1]

Hi,

I feel like this should be an easy measure to write but im struggling.

I have a dataset which includes a start date. I want to count and summarise the start date by month and year. 

Data example

Start date

15/06/2022

14/07/2022

18/07/2022

16/09/2022

20/10/2022

10/06/2022

27/06/2022

18/07/2022

18/07/2022

26/07/2022

12/08/2022

09/09/2022

28/09/2022

03/10/2022

11/10/2022

11/10/2022

08/06/2022

Required output

Month	#
Jun-22	4
Jul-22	5
Aug-22	1
Sep-22	3
Oct-22	4

I have a calendar table but as im wanting to display by month and year i cant figure out how to display the date in that format without it being in text format. I then cant match the data as its date to text fields

Thanks

[ryan_mayu · Accepted solution]

@Davebryant1 

i even don't think you need a measure.

if you want to create a measure , try this

Measure = count('Table'[Start date])

pls see the attachment below

[Davebryant1]

Thanks Ryan, i've got both ways to work. 

Easy when you know how!

Cheers

[ryan_mayu]

you are welcome