How to Achieve dynamic data retrieval: Current month + 12 months prior using SQL in Dashboards

Depending on where you are running this SQL query, can't you get the year from the user entry and use a loop to build your SQL query like something similar?

dim strUserTime as String
dim intUserYear as integer = Left(strUserTime,4)
dim intUserPriorYear as integer = intUserYear-1
Dim lstTimeList As new List(of String)
For each i = 1 to 12
  lstTimeList.Add($"{intUserPriorYear}M{i}")
Next

Now you can then do String.Join(", ", lstTimeList), to get the whole list of time.