Forum Discussion

ivannye's avatar
ivannye
Icon for Helper I rankHelper I
4 years ago
Solved

create index column in DAX

Hi, I have a column name Employee ID, and endofmonth column that goes like this: EmpID   EndofMonth 19000   09/08/2019 19000   10/08/2019 19001   09/08/2019 19001   10/08/2019 19001   11/08/201...
Need Help
Tips and Tricks
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi ivannye ,

    Try to use the following dax to create a new column:

    index = RANKX('Table', RANKX('Table','Table'[EmpID],,ASC,Dense)+0.01*RANKX('Table','Table'[EndofMonth],,ASC,Dense),,ASC,Dense)

    Final output:

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Hi ivannye 

you can directly create a index column from Transform Data tab. PFB screenshot for your reference:-

 

Thanks,

Samarth

ivannye's avatar
ivannye
Icon for Helper I rankHelper I
4 years ago

Hi,

 

I already know but it returns a duplicate value when I do it. I would like to do it using dax.

  • Samarth_18's avatar
    Samarth_18
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi ivannye 

     

    Could you please share with example what you want and what is the output you are getting?

     

    Thanks,

    Samarth