Forum Discussion
Duplicated column affects original when adding filters
In power query, are you creating a new column in the table by duplicating one of the columns?
If you filter any column in that table, the whole table is filtered.
Or are you creating a new table?
Resident RockstarHi, willielo,
where are you doing this? In Power BI Desktop or Transform data/Power Query?
If you are in Power BI Desktop and duplicate a column within a table, a filter on a column will affect which rows are shown, so you will not be able to choose different values in the original and the duplicate column.
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Hi! thanks for the responds!
I am inside the transform data/power query when doing this. Do you need to use a certain function to not affect the original column when duplicating inside transform data/power query?
- sturlaws
In power query, are you creating a new column in the table by duplicating one of the columns?
If you filter any column in that table, the whole table is filtered.
Or are you creating a new table?