Linked tables with slicer

I have a related question about using slicer to filter data in tables with no established relationship. Say I have a list of dates, EOM (End of Month). It goes like this: EOM 1/31/2000 2/28/2000 ... 1/31/2020 I put this in a slicer. Somehow I still get a continuous date displayed as I slide the slicer left or right. However, if I display the end data points of the slicer I do get an EOM such as 9/30/2019 (but the last date could be 10/19/2019 displayed as the right-most date in the slicer). Here's the question. If I have a table with Period (YYYYQ) how do I filter this using a slicer? YYYY is Year & Q is Quarter. This table looks something like this: Ticker, Period, Value Ticker1, 20193, 3.45 Ticker2, 20193, 50.20 ... TickerN, 20193, 17.50 Ticker1, 20194, 4.51 Ticker3, 20194, 62.30 ... TickerZ, 20194, 100.23 ... If I don't have Period, but Date. Then I could use a measure such as this: SelectedDate = Calculate(max(EOM[EOM]), AllSelected(EOM[EOM])) Say, I wanted to sum up all the value based on the selected ending EOM. Say, it's 9/30/2019, not 1/31/2020. My other measure would be this: ValueSelected = Calculate(sum(table[Value]), Filter(table, table[Date]=table[SelectedDate])) That is, if I have Date rather than Period. How would I do this if I have Period as above? Frankly, I don't even know why SelectedDate = Calculate(max(EOM[EOM]), AllSelected(EOM[EOM])) give the correct result when SelectedQtr = Calculate(max(EOM[EOM].[Quarter]), AllSelected(EOM[EOM])) gives 4 & SelectedYear = Calculate(max(EOM[EOM].[Year]), AllSelected(EOM[EOM])) give 2020 It seems the last 2 max assess the entire EOM table rather than the selected band. I think SelectedQtr give 4 because other years has 1,2,3,4 & 4 is the max. There's no way I could structure the quarter to be the latest selected quarter from the latest year.