Edit/Replace in a DAX measure

[Anonymous]

Hello,

I've made some changes to my excel data for the sake of uniformity, but now I need to go and adjust my DAX measures to reflect those changes.

Is there a function in Power BI similar to the "Replace" function in excel (picture)  so I don't have to manually change every single occurance of this data in my measures?

Thanks in advance for your help!

[DataInsights · Accepted solution]

@Anonymous,

You can achieve this with Tabular Editor (free utility). In the Advanced Scripting tab of Tabular Editor, run the following:

var FromString = "Group 6 MS 404";
var ToString = "Group 6 (MS 404)";

foreach (var m in Model.AllMeasures)
{
m.Expression = m.Expression.Replace(FromString,ToString);
}

[randl068]

I've been using this method for a while but suddenly it no longer works, any idea why? Using that exact template fails to replace the values in the expressions i've selected.

[Anonymous]

@DataInsights 

Thank you so much! But, where do I find tabular editor?

Thanks again!

[DataInsights]

https://github.com/TabularEditor/TabularEditor/releases/tag/2.16.6