Extract and display the Last Word - Bi Service Report

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