Maybe use a Matrix? hard to say without more details or a dummy dataset.

...and post the CREATE TABLE script for the 'PersonalProfiles' table... just want to make sure that you've defined the columns properly. Using the wrong datatype could cause unexpected results.

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...