Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
please support with a solution for the below issue, i have column Data as below, i need the result to be as illustarted
Data | Result |
1-2-1-3-1 | 1-2-3 |
4-1-3-4-5-5 | 1-3-4-5 |
Solved! Go to Solution.
Try like
Text.Combine(List.Sort(List.Distinct(Text.Split([Column1], "-"))), "-")
Hi @HusseinKhalil ,
Does that make sense? If so, please accept the helpful answer as the solution. More people will benefit from this thread. Thanks in advance!
Try like
Text.Combine(List.Sort(List.Distinct(Text.Split([Column1], "-"))), "-")