Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hello everyone, 
I have a problem with a set of data. I have three different columns and I would like to know for each Code per month the sum of the Alert. 
For example: for the code 9765 I have 3 alerts in January. 
This is the set of date: 
| Code | Alert | Date | 
| 9930 | 1 | 05/01/2022 | 
| 301973 | 1 | 05/01/2022 | 
| 9765 | 1 | 10/01/2022 | 
| 9765 | 1 | 10/01/2022 | 
| 9765 | 1 | 10/01/2022 | 
| 13447 | 1 | 11/01/2022 | 
| 21745 | 1 | 12/01/2022 | 
| 9776 | 1 | 14/01/2022 | 
| 9300 | 1 | 19/01/2022 | 
| 21745 | 1 | 25/01/2022 | 
| 9776 | 1 | 25/01/2022 | 
| 301973 | 1 | 26/01/2022 | 
| 4823 | 1 | 27/01/2022 | 
| 9851 | 1 | 28/01/2022 | 
| 9851 | 1 | 28/01/2022 | 
| 301973 | 1 | 28/01/2022 | 
| 9765 | 1 | 02/02/2022 | 
| 9765 | 1 | 03/02/2022 | 
| 301973 | 1 | 04/02/2022 | 
| 9765 | 1 | 04/02/2022 | 
| 10072 | 1 | 04/02/2022 | 
| 9851 | 1 | 04/02/2022 | 
| 18861 | 1 | 07/02/2022 | 
| 9765 | 1 | 08/02/2022 | 
| 9300 | 1 | 08/02/2022 | 
| 9851 | 1 | 08/02/2022 | 
| 9851 | 1 | 10/02/2022 | 
| 9851 | 1 | 15/02/2022 | 
| 9851 | 1 | 15/02/2022 | 
| 21745 | 1 | 15/02/2022 | 
| 302986 | 1 | 16/02/2022 | 
| 9300 | 1 | 17/02/2022 | 
| 301973 | 1 | 21/02/2022 | 
| 21732 | 1 | 23/02/2022 | 
| 9851 | 1 | 25/02/2022 | 
| 21732 | 1 | 02/03/2022 | 
| 5376 | 1 | 04/03/2022 | 
| 10109 | 1 | 14/03/2022 | 
| 4823 | 1 | 15/03/2022 | 
| 9300 | 1 | 17/03/2022 | 
| 9851 | 1 | 17/03/2022 | 
| 21732 | 1 | 17/03/2022 | 
| 21732 | 1 | 17/03/2022 | 
| 9300 | 1 | 21/03/2022 | 
| 21732 | 1 | 22/03/2022 | 
| 9300 | 1 | 23/03/2022 | 
| 301973 | 1 | 25/03/2022 | 
| 21745 | 1 | 25/03/2022 | 
| 9300 | 1 | 29/03/2022 | 
| 21745 | 1 | 31/03/2022 | 
Thank you for the support!!!
Solved! Go to Solution.
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 9 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | 
| User | Count | 
|---|---|
| 23 | |
| 14 | |
| 11 | |
| 10 | |
| 9 |