Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

remove duplicates with commas using dax

‎07-02-2023 11:32 PM
atis,tis,dis, mis
bdis,mis
cdis,mis,dis
Labels:
Message 1 of 8
626 Views
0
7 REPLIES 7
Ahmedx
Super User
Super User

‎07-03-2023 12:43 AM

to know how to do it in power query watch my video

https://1drv.ms/v/s!AiUZ0Ws7G26RiTSEuVSwoP3RLq-s?e=fln8s9

= Text.Combine(
List.Distinct(
Text.Split([pro],",")),", ")

 

Message 6 of 8
584 Views
0
Anonymous
Not applicable
In response to Ahmedx

‎07-03-2023 02:11 AM

link doesnt work

Message 7 of 8
576 Views
0
Ahmedx
Super User
Super User
In response to Anonymous

‎07-03-2023 02:13 AM

https://dropmefiles.com/0Nq2A

Message 8 of 8
574 Views
0
Ahmedx
Super User
Super User

‎07-03-2023 12:37 AM

it would be better if you do it in power query

Message 5 of 8
586 Views
0
Ahmedx
Super User
Super User

‎07-03-2023 12:36 AM

Sample PBIX file attached

https://1drv.ms/u/s!AiUZ0Ws7G26RiTP7l9ywzl80goTu?e=BmmNwt

Screen Capture #1364.png

Message 4 of 8
587 Views
0
Ahmedx
Super User
Super User

‎07-03-2023 12:12 AM

Is this what you are looking for?

Screen Capture #1363.png

Message 2 of 8
598 Views
0
Anonymous
Not applicable
In response to Ahmedx

‎07-03-2023 12:31 AM

yes

 

Message 3 of 8
589 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All