Limit query results by filtering a column with a MAX function

Hi All,

I'm working on a report which pulls data from a database which contains about 200K rows per monthly snapshot. The report only has to contain data from the latest monthly period (ergo: the MAX or TOP 1 descending value of column "Period"). I can filter this in the report layer with DAX, but my goal is to filter it in the query editor itself, so the initial load won't have to load 200K times the amount of periods and will automatically pull new periods when the refresh hits. I've found the Table.Max and the List.Max functions, but i'm not quite sure how to use them correctly in the query editor.

Any thoughts?

Thanks in advance.