Forum Discussion
buttercream
Helper II
Helper IIHow 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
ryan_mayu
Super User
Super UserJust like what Greg_Deckler mentioned.
You can try do this in PQ
= Table.AddIndexColumn(#"Changed Type", "Index", List.Max(Table[Index]), 1)
pls see the attachment below
buttercreamThanks. Almost there. I should mentin that I'm looking to append the current data to the historical data. Doing this causes a circular error when using max.
- ryan_mayu
you can try to append query as New