Forum Discussion

Preetish_1's avatar
Preetish_1
Helper I
8 years ago
Solved

Calculated Index Column

Hello everyone,   I was wondering if someone could help me figure out how to create a calculated index column using DAX. I would like to use a user name column and a date column, indexing the first...
Need Help
  • vik0810's avatar
    vik0810
    8 years ago

    Use following DAX for the column

     

     

    Index =
CALCULATE (
    COUNTROWS ( Table ),
    FILTER (
        Table,
        Table[User] = EARLIER ( Table[User] )
            && Table[Date] <= EARLIER ( Table[ Date] )
    )
)
vik0810's avatar
vik0810
Resolver V
8 years ago

Use following DAX for the column

 

 

Index =
CALCULATE (
    COUNTROWS ( Table ),
    FILTER (
        Table,
        Table[User] = EARLIER ( Table[User] )
            && Table[Date] <= EARLIER ( Table[ Date] )
    )
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Can you do this from within a Summarize table as well or does it have to be a calculated column?

(And many thanks, this was just what I needed.)