One way to do this is to use a Calendar table, then you can filter for Month/Year.

Otherwise, you'd have to use something like:

WHERE [EventDate] >= '01-Jan-2018'...

you never check the destination table for existing records. Why not?

This should give you a start (although you might need a Calendar table to join to so you can PARTITION wherever you want.)
https://blog.bertwagner.com/heres-a-quick-way-to-generate-a-running-total-in-sql-server-f5654d310030

You'd just wrap this part in the INSERT statement:
SELECT *
FROM Ranked
WHERE Ranked.Rnk < 4
ORDER BY Ranked.StoreNo,
 Ranked.Rnk DESC

(well, you'd have to expand the *...)

One way of doing this is to wrap your query in a TOP predicate --- I'm using AdventureWorks2014 (because being able to test my answers hopefully keeps me from making...

Just gonna throw this out there...
What if you created a few variables in your report and grabbed the population size from somewhere? Then you can just divide by that?...

Maybe it's me, but I think the table design they gave you (if accurate) is horrible. Subjects are facts/information, and don't really belong in column names. Would be a lot...

Got lazy and used DelimitedSplit8K

SELECT TextTime
    , ca.Item
    , ca.ItemNumber
FROM
(SELECT '000.004.000' AS TextTime
UNION ALL SELECT '000.02.000'
UNION ALL SELECT '000.024.000') x
CROSS...

cor_dog, you can do all the DAX stuff in Excel, if you want. If you're lost, I would read Rob Collie's book. It's $30. If you're new to DAX, it's...

Got some data? Sounds like a DAX question, but maybe I've been doing too much PowerBI.
Should be easy if you join your data to a Calendar table... then you...

Here's an explanation of what a Tally or Numbers table is...
http://www.sqlservercentral.com/articles/T-SQL/62867/

Let me back up a step.  if you want to identify a Shipment etc, you can use an AutoNumber primary key. Sure, they're meaningless, but you can have foreign keys...