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

Hi All, I am currently facing a challenge with my SQL code in dashboards and would greatly appreciate your help in finding a solution. The issue at hand is that I have hardcoded the code to pull dat...