Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
oscarcu90
New Member

Merge 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?

 

oscarcu90_0-1717750189212.png

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@oscarcu90 

you can try to add a custom column in PQ

 

=if [Suppplier1]=[Supplier2] then [Suppplier1] else [Suppplier1]&[Supplier2]

11.PNG

 

or use DAX:

 

Column = if('Table'[Supplier2]='Table'[Supplier1],'Table'[Supplier1],'Table'[Supplier1]&'Table'[Supplier2])
 

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
oscarcu90
New Member

Simple but worked as a charm, thanks!

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ryan_mayu
Super User
Super User

@oscarcu90 

you can try to add a custom column in PQ

 

=if [Suppplier1]=[Supplier2] then [Suppplier1] else [Suppplier1]&[Supplier2]

11.PNG

 

or use DAX:

 

Column = if('Table'[Supplier2]='Table'[Supplier1],'Table'[Supplier1],'Table'[Supplier1]&'Table'[Supplier2])
 

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.