Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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.
If this post helps, then please consider accepting 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |