Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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!
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |