Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
99 | |
88 | |
72 | |
60 | |
59 |