Forum Discussion

buttercream's avatar
buttercream
Icon for Helper II rankHelper II
1 year ago
Solved

How to continue index column from another table?

Hello,   I have two tables.  A historical data table and a current data table.  I have an index column in the historical table.  How do I add an index column in my current data table that starts wi...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    you can try to append query as New

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, buttercream 

Thanks for the replies from ryan_mayu and Greg_Deckler. You can try their method, or try the following way.

1. Re-adding column Index.1

2. Sort descending and get the value corresponding to Index

3. Add an Index column to the current table starting with 5



Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum