Data Analytics
explore our new search
Power Query: Add Column Header Spaces
Power BI
Sep 29, 2022 12:00 AM

Power Query: Add Column Header Spaces

by HubSite 365 about Pragmatic Works

Data AnalyticsPower BILearning Selection

In this video, Allison will show you how you can easily add spaces in between words in your column headers by doing it in Power Query.

M, the Mashup language is very powerful and can be easy to use and modify. Allison shows how you can add a snippet of code to your Advanced Editor in Power Query and what else to modify in the existing code in order to get spaces in your column headers.

More about this topic

Power Query Pattern – Adding Spaces in Text within your data with Camel Case

In this week’s blog post, I created this Power Query Pattern, which I created to add in spaces for CamelCase text within a column. To get this to work for you, all that you do is need to make one change to the code.

Below is what the data looked like