Complex Dates compare

Hi andhiii079845 ,

Thank you for looking into it.

I have some question to it: 
1) Date is MM/DD/YYYY in your example?  Yes, Its a date column.
2) Are CY,LY,LLY separate columns? They all come from one date column. I seperated them by year to explain better.
Where are the metrics? I added test data (Please see below)
Date table Key joind to Fact tables

Do you have a example for it? Yes added 
3) If you select one month and there are more snapshot in this month, which one should be selected: all? the last one?  

This is good example.

They took two snapshots in 2022 , but previous year only one. 

If users selects 12/31/2022, or 12/03/2022 , the pattern shold be like below.

Thanks a lot.