Scenario:
Often people have problems with spaces in the abbreviations when importing data in Power BI Desktop. The sample data and the expected result are first provided below for the reader's reference.
Read more...
How to remove spaces from abbreviations in values in Power Query.pbix