Practice Power BI

Theory Into Practice

  • Home

Posts Tagged → Table.ColumnNames

Reorder Columns

posted in Power Query on June 27, 2021 by DAX_learner

I didn’t realize reordering columns in Power Query could be so complicated. Thanks to Gil Raviv for his solution.

Rename Columns Based on Position

posted in Power Query on September 23, 2020 by DAX_learner

In Power Query I select columns based on their name, unpivot other columns and load the data into the data model. Later, if the source columns get renamed, I get an error when I refresh the query.

Categories

  • DAX
  • Power Query
  • Visuals

Recent Posts

  • Working With Totals
  • Counter in a visual
  • multiple date fields in fact table
  • Dynamic X axis on charts
  • Running Total
 Share This
 LinkedIn

Share on Mastodon