Customize Tables Column names

[miguel1206]

Hi all, I got a question about table options, is possible change names that appears in table, automatically table do that:

Field1 | Field 2 | count of (Field 3) | Sum of (Field 4)

Can I set only:

Field1 | Field 2 | Field 3 | Field 4

Best regards

[Vvelarde · Accepted solution]

@miguel1206

Hi, Miguel the tables automatically change the name depends of the Summarization(Sum, Count, Average, etc)

But you can define a Default Summarization

In this case i change the default to Average. The "Unidades" still mantain and don't be change to Average.

[miguel1206]

Thank you!

[MarcelBeug]

A different interpretation and a Power Query solution (in which "PreviousStep" to be replaced with the name of the prevous step):

= Table.RenameColumns(PreviousStep,List.Zip({Table.ColumnNames(PreviousStep), List.Transform(Table.ColumnNames(#table(Table.ColumnCount(PreviousStep),{})), each Text.Replace(_,"Column","Field "))}))

[miguel1206]

Thank you! I'll try your solution

Regards