Extract and display the Last Word - Bi Service Report

[MikeGanem3]

 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

[ArwaAldoud]

I'm glad it helped you. Thank you

[ArwaAldoud · Accepted solution]

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