Forum Discussion

Muzda's avatar
Muzda
Frequent Visitor
4 years ago

Create/append a index column

Hi!

How to create/append a index(1,2,3,4,5...) column in existing table with dax without using any condition or filter formular.

Thanks. Any help is appreciated!

3 Replies

  • Muzda's avatar
    Muzda
    Frequent Visitor

    Thank you so much for the answer. I looked at the links you provide to me , but UNION() claim to have the same number of columns in both joined table. In my case I have a table of 9 columns, I want to append another column with a series of number.Here is example of table to demontrate:

    NameLocation
    MarryA
    AidaA
    JohnB
    MgdalenaC
    JohnE

    Now I want to apend column called index at the end with series of numbers such as 1,2,3,4,5...
    I know GENERATESERIES() can provide this series but then how I can add it to that table so that it become:

    NameLocationindex
    MarryA1
    AidaA2
    JohnB3
    MgdalenaC4
    JohnE5

    Thanks