I'm studying reports with Power view and Power Query, and I need to split the content of a column
For that I'm seeking the QUERY tab and the Edit button as below, but I don't find them.
What did I miss ?
Thanks
Technology Tips and News
I'm studying reports with Power view and Power Query, and I need to split the content of a column
For that I'm seeking the QUERY tab and the Edit button as below, but I don't find them.
What did I miss ?
Thanks
Hi WLID,
Based on your image and your description, you wonder to split a column in Power Query. But your case title is wonder to know how to split a column in Power Pivot, did you write the wrong title?
For split a column in Power Pivot. In Excel go to Data > Text to columns > Delimited > Space > Finish. Then take the data to PowerPivot.
For split a column in Power Query. Using the Query Editor in Power Query, a column of text can be split into multiple columns in two ways: by delimiter or by a number of characters.
By Delimiter parses a text value based on a common character into two or more columns. For example, a Name column as LastName, FirstName can be split into two columns based on the comma (,) character.
By Number of Characters parses a text value based on a character position within a text value.
Please refer to this article to get the methods about how to split a column in Power Query.
Hope its helpful.
Regards,
George Zhao
Thanks a lot George,
Definitely, I wrote the wrong title...