I took a different direction and created an xlookup on the supporting data table to find the entry for the first of the year for each row.