Is it possible to change an imported column into a calculated column?

[Anonymous]

I have a file I import that has a column with null column values. I would like to replace this imported column with a concatenation calculation that joins two other columns together programmatically. Is this possible without having to go through the process of creating the column each time I want to add a new value?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

With DAX, it is not possible to replace column values in place without adding calculated column.

You could try to achieve this requirement via Power Query Text.Replace and Text.ReplaceRange

Regards,

Yuliana Gu