Forum Discussion
Davebryant1
3 years agoFrequent Visitor
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-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
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
3 Replies
- ryan_mayuSuper User
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
- Davebryant1Frequent Visitor
Thanks Ryan, i've got both ways to work.
Easy when you know how!
Cheers
- ryan_mayuSuper User
you are welcome