Renaming columns

[nickathot]

Hi
I created a calculated table with 2 columns. The columns were created with default names of 'Value1' and 'Value2'.
How can you rename these columns as the name property is greyed out?

Or how can you create calculated table with specific column names?

[mlonsk]

Hi @nickathot
You need to change the DAX Expression where the columns are named.

The names of the columns are defined in the DAX Expression, which is why the Name property is greyed out.

[nickathot]

Hi @mlonsk

Thank you for your reply.

Unfortunately, that solution did not work as I require multiple rows.
Luckily for my colleague he came up with a alternative solution using DATATABLE

[nickathot]

To create a calculated table with multiple columns and rows with custom column names use DATATABLE, refer to image.

[mlonsk]

Neat solution. Mine was merely an example of how you can set the name through the DAX statement, but as @otykier said in his response, there is another way where you set the property "Name Inferred" on the column to false and can then change the name property:

[otykier]

You can rename columns of a calculated table without modifying the DAX, by setting the “Is Name Inferred” property of the column to “false”. Similarly, if you need to change the data type of a column (without modifying the DAX), you can set “Is Data Type Inferred” to “false” (this goes for calculated columns as well).