Power Query

Change Column name by postion - featured image

Change column name by position in Power Query (with 2 easy functions)

by BI Off The Grid

Do you keep getting the error that states The column ______ of the table wasn’t found? It’s because the column names in the source data have changed. The thing is, if we can control the column names in our query, it is much less likely…

0001 - Remove spaces in Power Query - Featured Image

Remove spaces in Power Query (the easy way)

by BI Off The Grid

If data comes to Power BI through downloaded CSV/Excel files or the internet, we often encounter unwanted spaces within the text. However, we rarely want these extra spaces within Power BI. Therefore, in this post, we are looking at how to remove spaces in Power…

« Previous
1
2