Splitting Columns without overriding

[edday]

hello,

Is there a way to split columns in Power BI (using delimiters) without overriding the original column? I want to retain the column that holds the original data, but copy and split its data into separate columns as well. 

thanks,

edday. 

[MarcelBeug · Accepted solution]

In the Query Editor you can first duplicate the column (tab Add Column) and split one of the two columns.