How to filter to latest period in Power Query

[smjzahid]

I have a column in my table  Programme called Period No. of type Whole Number, this contains 13 different period in a year. for eg.

I want to apply a step in my power query that would only filter the data for the maximum period in the table, as in the below example as of now I only want period 202002 to filter and load, (as this is the latest period) 

In the next month I want it to filter for period 202003 and so on (meaning only pick up the maximum period from the column. How do I achieve this in Power Query.

[camargos88 · Accepted solution]

Hi @smjzahid ,

Try this code for a custom column and filter the result:

if [Column1] = List.Max(#"Changed Type"[Column1]) then 1
else 0

Change the bold part with your last step name.