Dynamic Column Header Search

[JarrellCo]

I am wondering if it is possible to create a formula (m-code most likely I guess) that can search column headers that contain the current year value, then use that columns data to evaluate/compare with other data I have in other columns for the current year.
I have column headers that have 2023, 2024 and soon to have 2025...and want to only evaluate data for 2023...but I want to set the report up dynamically enough to adjust based on the current year. This way, when we roll into a new year, the bi report adjusts and uses data from the 2024 column(s).
I'm sure with the word Power in Power BI means it can do this! I just need some guidance on making it happen! I know you geniuses out there can help guide me through this please!
Thanks in advance.

[Ahmedx]

pls see my video

https://1drv.ms/v/s!AiUZ0Ws7G26RiTLPE9O8q4GBdd5_?e=HSQB11

Date.Year( Date.From( DateTime.LocalNow()))