cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lottieritchie
Helper I
Helper I

Replacing values in all measures or calculated columns

Hi, 

 

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? 

 

Thanks! 

1 ACCEPTED SOLUTION

HI @lottieritchie,

I think you can't directly do these on the power bi side, perhaps you can try to use some external tools to directly modify with power bi data model and its field reference.

External tools in Power BI Desktop - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
Jihwan_Kim
Community Champion
Community Champion

Hi, @lottieritchie 

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. 

HI @lottieritchie,

I think you can't directly do these on the power bi side, perhaps you can try to use some external tools to directly modify with power bi data model and its field reference.

External tools in Power BI Desktop - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors