Replacing values in all measures or calculated columns
Is there a way to change all references from one field to another across all measures or calculated columns?
For example, I have a field called Job_Priority that is used in a lot of calculated columns and measures, but I now want to use Job_Priorities2. Do I have to manually edit every measure or calculated column? Or is there a better way I can acheive this?
Please correct me if I wrongly understood your question.
In my case, and I am not sure how others do but in some cases they are changing all measures like you planned, I change the existing column name [Job_Priority] to [Job_Priority2], then I create a new column that is called [Job_Priority].
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Thanks for your quick reply. Unfortunately this doesn't work as the references just update to 'Job_Priority2' so the reference doesn't change over to my new column. I tried just renaming my new field to the name of the previous one hoping it would write over the references to it, but it doesn't allow this.