Forum Discussion
Solved
How to create a static index/serial column
Hello. I am looking to create a serial/index column in my table that is easy to reference when processing orders outside of Power BI. I have tried adding an index column to my table, but this d...
shaebert , The best power solution is to add an index column in the power query. If that did not work then you should bring it from the source.
What you are looking is a primary key(incremental id) that can be best done at source.
shaebert , The best power solution is to add an index column in the power query. If that did not work then you should bring it from the source.
What you are looking is a primary key(incremental id) that can be best done at source.
How can I dynamically do that in excel?
I did some research and found a way to create a dynamic / incremental index/serial column following the formula described here: https://www.thoughtasylum.com/2013/06/29/Auto-Incrementing-in-Excel/