Change the table and column reference by changing slicer selection

Hello 8B45830,

Can you please try this:

1. Combine your "Actuals F24", "Actuals F23", "Actuals F22", etc., into a single table called "Actuals". Add a new column called "Fiscal Year" to this table to distinguish between different years

2. Create a Dynamic Measure

Dynamic YTD Actual Data = 
VAR SelectedMonth = MAX('Calendar'[Date]) // Assumes the slicer selects a single month
VAR FiscalYear =
    SWITCH(
        TRUE(),
        SelectedMonth >= DATE(2022, 11, 1) && SelectedMonth <= DATE(2023, 10, 31), "F24",
        SelectedMonth >= DATE(2021, 11, 1) && SelectedMonth <= DATE(2022, 10, 31), "F23",
        SelectedMonth >= DATE(2020, 11, 1) && SelectedMonth <= DATE(2021, 10, 31), "F22",
        "Unknown"
    )
RETURN
    CALCULATE(
        TOTALYTD(SUM('Actuals'[Amount]), 'Calendar'[Period], "10/30"),
        'Actuals'[Fiscal Year] = FiscalYear
    )

Hope this helps!