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.
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.
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 |
---|---|
56 | |
27 | |
23 | |
15 | |
11 |
User | Count |
---|---|
76 | |
58 | |
46 | |
17 | |
12 |