oscarcu90New Member2 years agoSolvedMerge columns but avoid duplicating values Hi, I do not know if this is possible. I want to merge 2 columns but avoiding to merge values if the data is duplicated. How can I proceed? Show Moreryan_mayu2 years agooscarcu90 you can try to add a custom column in PQ =if [Suppplier1]=[Supplier2] then [Suppplier1] else [Suppplier1]&[Supplier2] or use DAX: Column = if('Table'[Supplier2]='Table'[Supplier1],'Table'[Supplier1],'Table'[Supplier1]&'Table'[Supplier2])
ryan_mayu2 years agooscarcu90 you can try to add a custom column in PQ =if [Suppplier1]=[Supplier2] then [Suppplier1] else [Suppplier1]&[Supplier2] or use DAX: Column = if('Table'[Supplier2]='Table'[Supplier1],'Table'[Supplier1],'Table'[Supplier1]&'Table'[Supplier2])
ryan_mayu2 years agooscarcu90 you can try to add a custom column in PQ =if [Suppplier1]=[Supplier2] then [Suppplier1] else [Suppplier1]&[Supplier2] or use DAX: Column = if('Table'[Supplier2]='Table'[Supplier1],'Table'[Supplier1],'Table'[Supplier1]&'Table'[Supplier2])
ryan_mayuSuper User2 years agooscarcu90 you can try to add a custom column in PQ =if [Suppplier1]=[Supplier2] then [Suppplier1] else [Suppplier1]&[Supplier2] or use DAX: Column = if('Table'[Supplier2]='Table'[Supplier1],'Table'[Supplier1],'Table'[Supplier1]&'Table'[Supplier2])
Related contentremove duplicate value within a rowRemove Duplicate Values in ColumnFilter a column with duplicate values based on the highest Index valueDuplicate ValueMerge duplicates data in columns
