Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
Proud to be a Super 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
Proud to be a Super User!
Thanks Ryan, i've got both ways to work.
Easy when you know how!
Cheers
you are welcome
Proud to be a Super User!
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |