Create new table that includes columns from other table whose column header equal a variable

[Anonymous]

Hello,

I have a table like that is like this

Value 1  ||   Value 2   ||  2019  ||  2020  ||  2021  ||  2022 ||   2023

I want to create a table that includes Value 1, Value 2, this year and year after this dynamically. i.e. if this year is 2021 then my new table will be:

Value 1 ||   Value 2  ||   2021  ||   2022

How can I achieve this?

Many thanks,

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

You can do it in power query. Create a parameter :

Then create a new blank query :

let
    Source = Table.SelectColumns(Your original query,{"value1","value2",Text.From(Parameter1),Text.From(Parameter1+1)})
in
    Source

Please refer to the sample pbix file.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai