Dynamic Dates for 13-Month Trend

Hi -

I am attempting to get a dynamic 13-month trend that will update based on the date I select in a drop-down.

For example, when I select February 2025, I want the trend to show February 2024-February 2025 or when I select January 2025, I want to see January 2024 - January 2025, etc. 

I can't use a date range filter due to other visuals on the page that are only for the specific reporting month. Also I don't want to allow free range filter, only 13 months back from the month selected.

Based on some googling / copilot help I completed the following steps, but the range is still not coming through correctly. Any help greatly appreciated!

Step 1: Create SelectedMonth Measure on 'Calendar' Table

Step 2: Create SelectMonthColumn

SelectedMonthColumn = [SelectedMonth]

Step 3: Create StartDate Measure on 'Calendar' Table

StartDate =

DATE(YEAR([SelectedMonth]) - 1, MONTH([SelectedMonth]), 1)

Step 4: Create StartDateColumn

StartDateColumn = [StartDate]

Step 5: Create '13_Month_Trend' table with start date and end date dynamic based on measures / columns created in steps 1-4. This is where things appear to be going wrong, with this table returning dates Jan 2024 - Dec 2025.

13_Month_Trend =

VAR EndDate = MAX('Calendar'[SelectedMonthColumn])

VAR StartDate = EDATE(EndDate, -12)

RETURN

    ADDCOLUMNS (

        CALENDAR (StartDate, EndDate),

        "Year", YEAR([Date]),

        "Month Number", MONTH([Date]),

        "Year Month", FORMAT([Date], "YYYY-MM"),

        "Day", DAY([Date]),

        "Day of Week", WEEKDAY([Date]),

        "Quarter", QUARTER([Date]),

        "Quarter Year", YEAR([Date]) & " Q" & QUARTER([Date])

    )

 

 

 

Here is a screenshot of the results I'm getting. When filtered for February 2025, I would expect the table to start at 2/2024 and end with 2/2025. However, it just showed Jan 2024 - Dec 2025, no matter what i select in the dropdown.