topic Re: How can I make sure that the filters on DAX do not get lost after renaming? in DAX Commands and Tips

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

82186 — Fri, 28 Jun 2024 11:30:18 GMT

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?

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

DataDazzler — Fri, 28 Jun 2024 12:02:06 GMT

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.

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

82186 — Fri, 28 Jun 2024 12:16:40 GMT

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.

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

Anonymous — Mon, 01 Jul 2024 02:40:45 GMT

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