Forum Discussion

jdormer's avatar
jdormer
Helper I
9 years ago
Solved

Concatenate Alphabetically

Hi,    I am building a report on data pulled from a SharePoint task list. One of the fields is "Assigned To" which can have multiple values. This field is available in Power BI as a "record," which...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    jdormer,

    Firstly, after your split your column, replace the space in your data with semicolon.


    Secondly, merge the two columns using “Merge Columns” feature.


    Thirdly, create a custom column using the following formula.

    =Text.Combine(List.Sort(Text.Split(Text.From([Merged]), ";"),Order.Ascending),";")


    For more details, please review this PBIX file.


    Regards,

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

jdormer,

Firstly, after your split your column, replace the space in your data with semicolon.


Secondly, merge the two columns using “Merge Columns” feature.


Thirdly, create a custom column using the following formula.

=Text.Combine(List.Sort(Text.Split(Text.From([Merged]), ";"),Order.Ascending),";")


For more details, please review this PBIX file.


Regards,

 

jdormer's avatar
jdormer
Helper I
9 years ago

Anonymous thank you! To clarify, The result I am looking for is that both columns show as "Jane Doe; John Doe;" so the steps provided actually go a bit further than necessary for my use case. I was able to use the third formula you provided to achieve the result I desired. Thanks again!