What I want to do is create a new table with the date of 01/01/2022, which then loads each asset and adds the MAX measurement with a date less than 01/01/2022, then loops back subtracting a month from the date to go to 01/12/2021 and loads the MAX measurement again, until it hits 2018.
So essentially it's a history of the measurements taken, going back in time so I can track the measurements over a date range on a line chart.