I have the following table in power query:

I’m trying to return the latest files for BOTH words “RAM” and “SoCal”. In this case, the return files would be:

RR RAM 2024-07-08.xlsx
RR SoCal 2024-08-05.xlsx

How would I write a function to do this?

I tried:

= Table.SelectRows(GetDateFromFileName, let latest = List.Max(GetDateFromFileName[Text Between Delimiters]) in each [Text Between Delimiters] = latest and (Text.Contains([Name], "RAM") or Text.Contains([Name], "SoCal")))

But it did not work.

Thank you