Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dbernabefdez
Frequent Visitor

How to replace text in Bulk for Calculated Columns -- Tabular Editor

Hi Community

 

I´ve found this script to change in bulk measures using Tabular Editor:


var FromString = "Text1";
var ToString = "Text2";

foreach(var c in Selected.Measures)
{
c.Expression = c.Expression.Replace(FromString,ToString);
/* Cycle over all measures in model and replaces the
FromString with the ToString */
}

 

 

It works pretty good for measures but dont seem to work for Calculated Columns because I get the following error.

 

dbernabefdez_0-1674819884560.png

 

 

 

Does anyone know how to solve this issue???

 

Thanks in advance

 

Best

1 ACCEPTED SOLUTION
LQuedas
Resolver II
Resolver II

Hey @dbernabefdez 

 

After looking at the documentation and doing an example you should try the following code

 

var FromString = "Text1";
var ToString = "Text2";

foreach(var c in Selected.CalculatedColumns)
{
c.Expression = c.Expression.Replace(FromString,ToString);
/* Cycle over all measures in model and replaces the
FromString with the ToString */
}

 

Hope it works for you.

 

Cheers, LQ

 

 

 

View solution in original post

2 REPLIES 2
LQuedas
Resolver II
Resolver II

Hey @dbernabefdez 

 

After looking at the documentation and doing an example you should try the following code

 

var FromString = "Text1";
var ToString = "Text2";

foreach(var c in Selected.CalculatedColumns)
{
c.Expression = c.Expression.Replace(FromString,ToString);
/* Cycle over all measures in model and replaces the
FromString with the ToString */
}

 

Hope it works for you.

 

Cheers, LQ

 

 

 

WOUU incredible!!!! Works great

 

I was making the mistake of using ""foreach(var c in Selected.Columns)"" instead of ""foreach(var c in Selected.CalculatedColumns)""

 

Thank you so much for your help

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.