How can I make sure that the filters on DAX do not get lost after renaming?

[82186]

Tell me please There is a column "Aggregate name" in this column there are different names of signals. I don't like these names and I want to rename them, for this I use the SUBSTITUTE command.

Code:

Name of the units= SUBSTITUTE([Unit name],"DB signal ","Signal 1")

Let's say that at some point in time I want to rename it from "Signal 1" to "Signal 2" After renaming, the filters will go wrong

How can I make sure that the filters on DAX do not get lost after renaming?

[Anonymous · Accepted solution]

Hi, @82186 

As @DataDazzler said, dynamically replacing text in text format is not possible, and the current version doesn't support this feature. Is what you were told before renaming column names/DAX names? Or you can wrap the New Signal name into Measure for each change later on.

New Signal = "Signal 2"

Name of the units =
SUBSTITUTE ( [Unit name], "DB signal", [New Signal] )

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[DataDazzler]

Trying to change the values of a column with DAX is not a best practice. Try to solve it just with a transformation with Power Query. The case you want to do I think is not possible, as you can not use the renamed variable as a filter.

[82186]

I tried it... the result is the same ... after renaming, everything gets lost I was told that it is possible so:

---

@DataDazzler wrote:

Trying to change the values of a column with DAX is not a best practice. Try to solve it just with a transformation with Power Query. The case you want to do I think is not possible, as you can not use the renamed variable as a filter.

---

But I'd like to see the code.