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.