Replacing an existing column in all measures and tables.

[koningroel]

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.

[v-chuncz-msft]

@koningroel,

Just remove the old column and then rename the new column.

[koningroel]

I tried that, everything broke

[v-chuncz-msft · Accepted solution]

@koningroel ,

You may also try to replace the value.

https://community.powerbi.com/t5/Desktop/Power-Query-change-input-data/m-p/595986#M283079