Crear un Index (index) en dax power BI

[Syndicate_Admin]

Hello good day, I would like to create a calculated field, that gives me the number of columns, and works as index, since I know that you could in power query, but I occupy that it is in specific in dax or power bi, I do not know if I explain, but basically it is an index, that at the time of adding a new row I count consecutively, and when you delete the row it is deleted consecutively, that is, as a count rows, which is the process automatically

Thank you.

[FreemanZ · Accepted solution]

It is doable via DAX, but, please do it in Power Query or Excel. 

In PQ, you just need an index column, 

In Excel, you just need to write =ROW(), 

That's it. 

In DAX, you need this,

INDEX3 =

VAR _Index= 'Table'[Index]

RETURN

    COUNTROWS(

        FILTER(

            'Table',

            'Table'[Index]<_Index

        )

)+1

there are other ways with RANKX, like this:

INDEX2 =

RANKX(

    ALL('Table'[Index]),

    'Table'[Index],

    ,

    ASC

)

but all share a major flaw: you need comparable values in a columnm, which is not always readily there.