Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to concatenate two strings but really my concatenation should be indifferent from the column in which they appear
What I have
a b > should concatenate as a, b
a c > should concatenate as a, c
b a > should concatenate as a, b (same as first case)
This is I really don't care about the order just the combinations. I thought I could resolve this by sorting before concatenating but can not figure out how to do that. Appreciate any assistance
Table is large so looking for something lightweight if possible
Solved! Go to Solution.
To accomplish like:
Add Column
Custom =
Record.ToList([[Column1],[Column2]])
Add another Column
Custom.1 =
List.Sort([Custom])
Extract Values from Custom.1
Proud to be a Super User!
To accomplish like:
Add Column
Custom =
Record.ToList([[Column1],[Column2]])
Add another Column
Custom.1 =
List.Sort([Custom])
Extract Values from Custom.1
Proud to be a Super User!
Thanks for your help.
In the end I used if / then and compared string 1 to string 2. I was not aware that I could compare strings to determine order.
However your method is much more scalable (longer list) so appreciate it as well
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
67 |
User | Count |
---|---|
124 | |
112 | |
98 | |
81 | |
72 |