Last Month and Same Month Last Year
I'm working on ETL do get the last month data and same month last year.
As it will be rolling so I don't want to do the calculation calling the Month November only in the data. (like if last month is Oct then the result will be Oct 2021 & Oct 20202 and if the last month is Nov then Nov 2021 & Nov 2020 and so on)
Any Ideas, how I can achieve this.