Sum of values from each month and create visual

[Rajasekar]

I have a table with values like Date (Month or Week) where the resources are moving away from the organization . I need to sum up and show how many resources are moving for each week/month. For eg: In Jan month 3 resources are moving, Feb month 2 are moving and then March month 7 and so on. 

Now I need to create a visual (any) by sum up and show like Jan - 3, Feb - 5 (3+2), March - 12 (3+2+7). Also include the Current date/month/week as a line in the same visual

[Gokul_G16]

Dear @Rajasekar ,

Can be have a nay snap for better understading ..
Regards,
Gokul

[Rajasekar]

Hi @Gokul_G16 

This is my raw data 

Date	Number of resources
28-04-2023 00:00	1
30-09-2023 00:00	1
19-05-2023 00:00	1
19-05-2023 00:00	1
13-03-2023 00:00	2
16-06-2023 00:00	3

I have filter out the month alone from power query editor

Month	Number of resources
April	1
Sep	1
May	1
May	1
March	2
June	3

Now, I'm looking for a solution to create a visual by summing up the values from each month March - 2, April - 3 (2 from March and 1 from April), May - 5 (March - 2, April - 1, May - 1+1) and so on

Month as X- axis and Values as Y - axis. Also need to add current month as a line in the same visual