Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Combine like Names

Hi,

I am newer to PowerBI and am needing some help getting names combined. I have a large list of names where some have the middle initial and some don't some have a space and a comma some just a comma and am needing a quick way to combine these. Almost all of the rows are riddled with dirty data can someone help me with how to clean it up? Thanks so much in advance!

 

Need Help
Tips and Tricks

1 Reply

  • rsbin's avatar
    rsbin
    Community Champion
    3 years ago

    Anonymous ,

    That is some ugly data you have been dealt.  This will take some work, but I think I can get you started.

    First thing I would do is in Power Query, copy your Provider column.  Then on this new column use the Split by Delimiter function using the comma "," as your delimiter.

    Then you may want to split your new columns again but this time using the space as your delimiter.

    Then using Power Query or DAX, you can use the multitude of Text functions that are available to further clean the data or combine first and last names.

    This will be much trial and error, but at least I hope this gets you started.

    Regards,