Dynamic Column Name

[sabeensp]

Hello,

I have a table as shown below. I have to plot the data in Grid, but column needs to be actual year. Every Year, Year will increment such as current Year + 1, + 2, and so on. So I cannot simply change the Colum Header. Table Field Names will not change in the Database. Is there a way in M-Query to change teh column nae such as YEAR(Now()), YEAR(Now()) +1 and so on. Please advice how to accomplish this?

[parry2k]

@selpaqm does the column name always like yr1 yr2 yr3...if yes then I can get you the solution which will be dynamic

[sabeensp]

@parry2kYes, column name will always be the same. Yr1, Yr2, and so on

[parry2k · Accepted solution]

@sabeensp see attached, look at table called Table in power query and it take the current year as a base and then replaces column names accordingly. It can be improved further but I think it is a good start.

[mahoneypat]

I would have approached it the same way @parry2k , with Table.ColumnNames and List.Zip.  A small change to reduce the number of steps would be to use this formula to make the list of Years for the column names with this:

=List.Transform({-1..3}, each Number.ToText(currentYear + _))

Regards,

Pat

[parry2k]

@mahoneypat agreed, assuming column numbers are in the same order and that's the reason I decided to not go with that path but thanks for pointing it out.

[selpaqm]

Hi,

did you try to change it from Transform Data section.

On home section click Transform data, then choose related table from queries section. change the table column headers with double click on it or just right click and rename it. this will be added to Applied steps section and even you refresh the data it will replace them by itself.

[sabeensp]

@selpaqmHow would that work next year when year will change next year?