Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Within M Language change "Last, First" Name to "First Last"?

Hi all,   Thank you to everyone for this continued support on this community.  It has been incredibly helpful with getting through this project.  So continuing that path...   I have code that loo...
Need Help
Tutorial Requests
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    Try this code on add a new column for Power Query:

     

    Text.Combine(List.Reverse(Text.Split([Column1],",")), " ")

     

     

    Did I answer your question? Mark my post as a solution!
    Ricardo

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
6 years ago

Try using 'Add Column from examples' to see what powerbi comes up with.  Give it some good examples .

Anonymous's avatar
Anonymous
Not applicable
4 years ago

sweet. thank you! it gave me this: let splitConsultant = Splitter.SplitTextByDelimiter(", ", QuoteStyle.None)([Consultant]) in Text.Combine({splitConsultant{1}?, " ", splitConsultant{0}?})