Changing Columns Names based on parameter/List/Values

[Gopal2704]

Hi guys,

Need help in the below issue:

I have a a list of files named as Name of File_Month_year.xlsx. After transformantions I get a seprate "Year" column having values 2023, 2022, 2021.

But for custom columns i need to keep changing the column names like BUD 2023 - M01, BUD 2022 M02 etc.
Can change the values using a Parameter like :

Parameter 1 : N = 2023

Parameter 2 : N+1 = 2024

Parameter 3 : N+2 = 2025

And so on and call them as :

= Table.DuplicateColumn(#"Bud - Year - M12", "T1 - 2023 - M12", Parameter4)

Is there a way to do it ?

[ppm1]

Not totally sure what you mean, but yes you can make a parameter for a given year, or (maybe better) a query that dynamically gives the current year with Date.Year(DateTime.LocalNow()). You can then use it in column renaming by concatenating the desired text with Text.From(YearValue + 1), for example.

Pat