Filter Date Table by "Other Table" to be less than or equal to the Max Date of the "Other Table

[cflynn_29]

Hi.

I have a Date Table which goes from 1990-2050 and i have another table of of values and dates "Other Table" which has a MaxYear of 2020 I've run the MaxDate in Power Query to get that Max date. This is because as values are added to  more years 2021..2022...etc i want it to automatically to update that MaxDate.

I want to be able to filter the Date Table up to the MaxDate in the "Other Table" which right now is 2020, so between 1990-2020.

Is there any way to do this?

[AntrikshSharma · Accepted solution]

@cflynn_29 In th date table you can create a new step Table.SelectRows ( PreviousStep, each [Year] <= List.Max ( OtherTable[Year] ) )