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
Thanks for any advice
Mike