How to change the calendar table end date in power bi?

Question

Here is my problem, I want to change the end date of my calendar table based on what I have selected in the "Previous 12 Months Dates Table".

I used my "Previous 12 Months Dates Table" as a dropdown slicer filter and get the max date in that table and used it in my calendar table as my end date.

I tried a measure that returns the max date from my "Previous 12 Months Dates Table" and also I try to debug by displaying my measure value in the table chart and selecting a specific date in the dropdown slicer and it works fine.

But when I used that measure in my "Calendar Table" and try to debug it will return the default max date, not the date that I selected in my dropdown slicer.

Here is the behavior I wanted to achieve. For example, if I select "EOMONTH" Jan 2022, it will return the previous 12 months' view from "EOMONTH" Jan 2022 and also it will calculate 12 months rolling average "EOMONTH" Jan 2022.

The previous 12 Months View and 12 months rolling average is working as I expected when I try to change the Calendar end date manually. that is why my only problem is how to change my calendar end date based on the selected date in the dropdown slicer.

Thanks in advance.