Calculate difference of Count of Incidents, group by month.

[xyzsam]

Hey Everyone, i need help with below question

I have two tables 

 

i want to calculate difference of count(AllIncidents) - count(ActionableTickets) per month basis. (for all months)
e.g
Desired Outcome: another table
Year       Month  Difference
2021       Jan        2003
2021       Feb       3615
2021       Mar       7369
2021       Apr        1628
2021       May       1947
.....           ......         ......

Can some one please help me on this ?

@amitchandak@Greg_Deckler 

 I would appreciate any input on this. Thanks

[CNENFRNL]

A most straightforward solution is to simply merge these 2 table by columns Year&Month in Power Query, it's done.

[xyzsam · Accepted solution]

Thanks for the reply, but how would it calculate the difference between count(AllIncidents) - count(ActionableTickets) for each month