Getting Power Query to add new values to the bottom
Results 1 to 6 of 6

Thread: Getting Power Query to add new values to the bottom

  1. #1
    Board Regular
    Join Date
    Aug 2018
    Posts
    96
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Getting Power Query to add new values to the bottom

    Hi All,

    I have searched the internet for a solution but cannot find one. can someone help me with Power Query in excel.

    so i have separate tables for items which can contain a varied amount of rows. i then have a merged copy of all these individual tables in another tab as one big table. so all table headers are the same etc. its all just merged into one. i am facing a problem where when i add a new value in my individual tables and refresh my merged table the value gets added where the rest of the data sits. normally this wouldn't be an issue but in my case it is as i need new values to be added to the bottom of the table, does anyone know how i can do this?

    any help is much appreciated!

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,680
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Getting Power Query to add new values to the bottom

    maybe use DateTime.LocalNow() then sort asc
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    Board Regular
    Join Date
    Aug 2018
    Posts
    96
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Getting Power Query to add new values to the bottom

    @sandy666 sorry for not understanding fully im no expert with this (As you may be able to tell) where and how do i add this?

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,680
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Getting Power Query to add new values to the bottom

    Quote Originally Posted by DMO123 View Post
    its all just merged into one
    to the merged table add custom column with mentioned function. it will give you date and time. sort ascending. remove this column.
    now you can add new data into your source table(s) and after refresh you should see new data at the bottom of the result table
    Last edited by sandy666; Sep 12th, 2019 at 11:39 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  5. #5
    Board Regular
    Join Date
    Aug 2018
    Posts
    96
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Getting Power Query to add new values to the bottom

    @sandy666 thank you i got it working!

  6. #6
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,680
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Getting Power Query to add new values to the bottom

    you are welcome

    have a nice day
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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