Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Doing operations on columns dynamically

Hi,   I have a source (Excel) with values (rows) by month ids (columns).   I need to make operations on these columns, for instance, division.   The problem is that these columns headers will c...
Need Help
  • edhans's avatar
    edhans
    4 years ago

    HI Anonymous 

    I wrote an article on how to rename columns by their position.

     

    Renaming A Column In Power Query Based On Position — ehansalytics

     

    So you need to do that, rename all columns (assuming position doesn't change) to a standard name, then do any transformations on those newly named columns.

     

    If the columns are changing position and names, I don't know how that would work. Cannot compensate for two variables like that.

edhans's avatar
edhans
Community Champion
4 years ago

HI Anonymous 

I wrote an article on how to rename columns by their position.

 

Renaming A Column In Power Query Based On Position — ehansalytics

 

So you need to do that, rename all columns (assuming position doesn't change) to a standard name, then do any transformations on those newly named columns.

 

If the columns are changing position and names, I don't know how that would work. Cannot compensate for two variables like that.