Forum Discussion
Anonymous
3 years agoNot applicable
remove duplicates with commas using dax
| a | tis,tis,dis, mis |
| b | dis,mis |
| c | dis,mis,dis |
7 Replies
- AhmedxSuper User
Is this what you are looking for?
- AnonymousNot applicable
yes
- AhmedxSuper User
- AhmedxSuper User
it would be better if you do it in power query
- AhmedxSuper User
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],",")),", ")- AnonymousNot applicable
link doesnt work