Forum Discussion
Helper IExtract and display the Last Word - Bi Service Report
Is itpossible to display only the last word of the cell value in each row of a column, without using "Add Column -> Extract"? If not, then how do I extract in Desktop using "Add Column -> Extract"?
Col1 Col2
Title Power BI for Dummies
Class Microsoft Power Apps
In the table above, I want to display
Col1 Col2
Title Dummies
Class Apps
Extract in Power BI Desktop, follow these steps:
- Open Power BI Desktop.
- Go to the Home tab and click Transform Data to open Power Query Editor.
- Select the column (Col2).
- Go to the Add Column tab and click Extract → Text After Delimiter.
- Set the delimiter to a space ( ) and choose Last.
- Click OK to create the new column.
- Click Close & Apply to save the changes.
If this response was helpful, please accept it as a solution and give kudos to help other community members
2 Replies
- ArwaAldoud
Super User
Extract in Power BI Desktop, follow these steps:
- Open Power BI Desktop.
- Go to the Home tab and click Transform Data to open Power Query Editor.
- Select the column (Col2).
- Go to the Add Column tab and click Extract → Text After Delimiter.
- Set the delimiter to a space ( ) and choose Last.
- Click OK to create the new column.
- Click Close & Apply to save the changes.
If this response was helpful, please accept it as a solution and give kudos to help other community members
- ArwaAldoud
I'm glad it helped you. Thank you