Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
in Power BI by 11 11 15
I am using Power Query and have a column called Full name, I want to split this column to a first name and last name how to do that using power query Editor in Power BI desktop

1 Answer

0 like 0 dislike
by 23 26 40
selected by
Best answer

In Power BI, you can use split by a delimiter to split a string based on a particular delimiter as the following:

  1. Click on "Edit Queries" to access the Power Query Editor.
  2. Right-click on the header of the column > Select split column - By delimiter
    Power BI split column - By delimiter

  3. Select space delimiter > choose each occurrence of the delimiter > click OK

If you don’t ask, the answer is always NO!