Forum Discussion
Solved
Multiple counts from the same table in one chart
I work for a courthouse and i have data that contains a table with columns casenumbers, incoming date, outgoing date (might be null). I know would like chart with a count of incoming and outgoing case per year, per month.
The tabel (simplified) :
| Casenumber | Date incoming | Date outgoing |
| 1 | 21-10-2020 | |
| 2 | 21-10-2020 | |
| 3 | 21-10-2020 | |
| 4 | 21-10-2020 | |
| 5 | 29-9-2020 | |
| 6 | 23-9-2020 | 1-10-2020 00:00 |
| 7 | 17-9-2020 | |
| 8 | 17-9-2020 | |
| 9 | 16-9-2020 | |
| 10 | 15-9-2020 | |
| 11 | 15-9-2020 | 21-10-2020 |
| 12 | 15-9-2020 | 21-10-2020 |
| 13 | 15-9-2020 | 29-9-2020 |
| 14 | 15-9-2020 | 23-9-2020 |
| 15 | 15-9-2020 | 17-9-2020 |
| 16 | 3-7-2020 | 23-9-2020 |
| 17 | 3-7-2020 | 17-9-2020 |
| 18 | 3-7-2020 | 17-9-2020 |
| 19 | 3-7-2020 | 16-9-2020 |
| 20 | 3-7-2020 | 15-9-2020 |
| 21 | 3-7-2020 | 15-9-2020 |
| 22 | 19-6-2020 | |
| 23 | 17-6-2020 | 15-9-2020 |
| 24 | 17-3-2020 | 15-9-2020 |
| 25 | 4-3-2020 | 15-9-2020 |
| 26 | 6-12-2019 | 3-7-2020 |
| 27 | 4-12-2019 | 3-7-2020 |
| 28 | 27-11-2019 | 3-7-2020 |
Is there a simple way of doing this?
Hi Steg - Try following the steps in here
https://finance-bi.com/power-bi-employee-count-by-month/
Hope this helps.
Cheers,
-Namish B
3 Replies
Hi Steg - Try following the steps in here
https://finance-bi.com/power-bi-employee-count-by-month/
Hope this helps.
Cheers,
-Namish B
Yes, Perfect, with some tweaking it worked!!
