Index for matching columns Power BI

[KitchenBy]

Hello, i have a  following formula in Power Bi:

let
Source = [Niestandardowe.2],
Custom1 =
Table.RenameColumns(
Source,
List.Zip(
{
Table.ColumnNames(Source),
List.Transform(
List.ReplaceValue(
List.FindText(
Table.ColumnNames(Source),
""),
"Cluster",
"TC",
Replacer.ReplaceText),
each if Text.Contains(_,"End")
then Text.Replace("_", "_","TC " ???????? )
else _ )
} ))
in
Custom1

I want to rename all columns which contain "End", rename to End1, End2, End3....

What i may to write instead "???????" i my code?

Thanks.

[Idrissshatila]

Hello @KitchenBy ,

You could double click on the column name and change it.

If I answered your question, please mark my post as solution, Appreciate your Kudos👍

Follow me on Linkedin

[KitchenBy · Accepted solution]

You didn't quite understand me, look in my code, and you understand what i want to do.