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.
Hi,
I've a data base like the following, but I'd like to get the number of Request "Mode de traitement = TRAITEMENT IMMEDIAT" by month.
Request | Date | Mode de traitement
n°1 | 10/04/2018 10:45 | TRAITEMENT IMMEDIAT
n°2 | 10/04/2018 10:45 | TRAITEMENT IMMEDIAT
n°3 | 10/04/2018 10:33 | TRAITEMENT IMMEDIAT
n°4 | 10/05/2018 10:06 | TRAITEMENT IMMEDIAT
n°5 | 10/05/2018 09:57 | CREATION DOSSIER
n°6 | 10/05/2018 09:53 | CREATION DOSSIER
n°7 | 10/06/2018 09:52 | CREATION DOSSIER
n°8 | 10/06/2018 09:52 | TRAITEMENT IMMEDIAT
n°9 | 10/06/2018 08:27 | TRAITEMENT IMMEDIAT
n°10 | 10/07/2018 08:28 | TRAITEMENT IMMEDIAT
n°11 | 10/07/2018 08:29 | TRAITEMENT IMMEDIAT
n°12 | 10/07/2018 08:33 | TRAITEMENT IMMEDIAT
n°13 | 10/08/2018 08:46 | TRAITEMENT IMMEDIAT
n°14 | 10/08/2018 09:52 | CREATION DOSSIER
I tried to creat an other base with the months using the first day of each month ([Month] = 01/04/2018 ; 01/05/2018 ; ...) and adding a calculate column [#TraitementImmediatByMonth], but I didn't success. How could I get get the following result ?
Month | #TraitementImmediatByMonth
01/04/2018 | 3
01/05/2018 | 1
01/06/2018 | 2
01/07/2018 | 3
01/08/2018 | 1
Thank's for your help !
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 |
---|---|
12 | |
7 | |
4 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |