Multiple counts from the same table in one chart

[Steg]

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?

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous · Accepted solution]

Hi @Steg - Try following the steps in here

https://finance-bi.com/power-bi-employee-count-by-month/

Hope this helps.

Cheers,

-Namish B

[Steg]

Yes, Perfect, with some tweaking it worked!!