Forum Discussion

Davebryant1's avatar
Davebryant1
Frequent Visitor
3 years ago
Solved

Count dates within months

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-224
Jul-225
Aug-221
Sep-223
Oct-224

 

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

3 Replies