Bulk change to column name

[masplin]

Having build lots of calculated measures and columns i now find that one of my data columns has a misleading name as it is called "Unique Customers" but really should be "Unique Households" with "Unique customers" being a different definition. If this was excel I could just do a find and replace so every measure that has "unique customer" gets changed. Is there anyway to do this in Powerpivot as in the past i have change the column name and then searched for all the errors and corrected them one at a time. However while not only being painful slow has also resulted in completely unreadable data and corrupted data models.

Thanks for any advice

Mike

 

[DWig]

Is the data column a calculated column?

 

[masplin]

In this case no it is linked to an excel table. I have had both situation though both raw data column naming and calcualted column naming.