Forum Discussion
Column name changes in the data source errors in DAX
If you move to the step before Changed Type (i.e. before it breaks) and insert a step to rename the column from the new name (Number of Beds) back to your old name (Beds) that should result in the later steps working and the references to that field should then be recognised too.
parry2k wrote:DebbieE then change column name in PQ what it is looing for, not sure where is the issue
The isssue was in my initial post. It seems the fix is to rename everything back to the old column names before all the applied steps.
Then to rename to the new column names at the end of all the applied steps and DAX will then use the new column names
The issue was, simply fixing the step that stopped working to the new column names and applying, DAX would still be looking for the old column names
DebbieE exactly, DAX doesn't care as far as the name is the name you might have tons of transformation on the way but if you are returning correct column name (as per you original table) than DAX should work Anyhow seems like you are aleady on the right track.
Would appreciate Kudos 🙂 if my solution helped.