Forum Discussion

Preetish_1's avatar
Preetish_1
Icon for Helper I rankHelper 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] )
    )
)
Preetish_1's avatar
Preetish_1
Icon for Helper I rankHelper I
8 years ago

Hi,

 

Did you try a Calculated Column or a Measure?

As the above formula was for a Calculated Column.

 

 

mbuick's avatar
mbuick
Frequent Visitor
8 years ago

HI,

 

This is a calculated column as per the example script in the original post.

 

thanks.