Date count in the month

[spb]

Wish to count the number of starts in the month of the start date.. 

eg

ID  Start Date 

1 12/2/22

2 1/2/22

3 

4 6/4/22

5 

6 18/2/22

Required answer:

Starts:

Feb 22 - 3

Mar 22 - 0

Apr -1

[Anonymous · Accepted solution]

Hi @spb ,

Assuming you have your table loaded in power query like below:

Step 1:

Step 2:  Add a new calculated column in the same table, your table should now look like the screenshot below:

Month & Day = FORMAT(Sheet1[Start Date],"MMM")& " " & YEAR(Sheet1[Start Date])

Step 3: Create a new calculated table:

Table Count = 
ADDCOLUMNS(
SUMMARIZE(Sheet1,Sheet1[Month & Day]),"Frequency",COUNT(Sheet1[Month & Day]))

 
Step 4 : Final Output

Table Count = 
ADDCOLUMNS(
SUMMARIZE(Sheet1,Sheet1[Month & Day]),"Frequency",COUNT(Sheet1[Month & Day]))

Hope that helps!