Results 1 to 3 of 3

Thread: Moving a specific column to the begining with a dyanamic table

  1. #1
    Seeker gjohal's Avatar
    Join Date
    Nov 2018
    Posts
    15
    Articles
    0
    Excel Version
    2016

    Lightbulb Moving a specific column to the begining with a dyanamic table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi!

    I was wondering if anyone could help me with an issue I've ran into. I have a query that adds/deletes columns based on new information that it fetches however the last column or rather the Header for the last column in the query will always be the same. I wanted to move the last column to the beginning. My issue is that if I obtain new data and I refresh the query, an error will occur as Table.ReorderColumns requires the column headers to be listed and with columns being deleted and added that leads to an error.

    Is there any way around this? Is there a way to make a specific column the first column in the query without referencing other column headings?

    Thanks

  2. #2
    Acolyte Nick Burns's Avatar
    Join Date
    May 2017
    Posts
    75
    Articles
    0
    Excel Version
    Office 365
    Take a look at Gil Raviv's Reorder Column Function
    https://datachant.com/2017/01/18/power-bi-pitfall-4/
    Oh... by the way, YOU'RE WELCOME!

  3. #3
    Seeker gjohal's Avatar
    Join Date
    Nov 2018
    Posts
    15
    Articles
    0
    Excel Version
    2016
    Thanks a lot! The function worked and that site seems really helpful for in case I run into other issues.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •