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.
Hello,
I have quite an extensive PBI file, where I used a column called 'Uren' (hours) to calculate a lot of measures and calculated columns. However there's some data in this column, that shouldn't be there, so I made a new conditional column.
My question:
Is there a way to either replace my old column with my new column, or change the column used in all the measures, columns and tables to the new column?
I've tried simply renaming the column, both in PowerQuery as in PBI itself, but PBI is just too smart for that.
Solved! Go to Solution.
You may also try to replace the value.
https://community.powerbi.com/t5/Desktop/Power-Query-change-input-data/m-p/595986#M283079
Just remove the old column and then rename the new column.
I tried that, everything broke
You may also try to replace the value.
https://community.powerbi.com/t5/Desktop/Power-Query-change-input-data/m-p/595986#M283079
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |