Forum Discussion
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...
you can try to append query as New
buttercream You could get the MAX index from the table and seed a modified Sequential perhaps:
Sequential - Microsoft Fabric Community
In Power Query you could grab the max index and then modify the Index step:
= Table.AddIndexColumn(#"Changed Type", "Index", 0, 1, Int64.Type)
Replace the 0 with your max index from the other table.