How to change Date to Index

[aar0n]

Basically, i am trying to 'Normalize' time. So the earliest available date per name starts at 1, and increases by 1.

Name    -     Date    -     (New Index Column) 

Joe              1/1/2017             1

Joe              1/2/2017             2

Joe              1/3/2017             3

Bob             1/1/2017             1

Bob             1/2/2017             2

..........

Basically, i am trying to plot Sales on the Y- axis, and "Working Days" on the X-axis.

[v-ljerr-msft · Accepted solution]

Hi @aar0n,

Based on my test, you should be able to use the formula below to create calculate column in your table to add the index column in your scenario. 

Column =
VAR currentDate = Table1[Date]
RETURN
    CALCULATE (
        RANK.EQ ( currentDate, Table1[Date], ASC ),
        ALLEXCEPT ( Table1, Table1[Name] )
    )

Regards

[aar0n]

Thank you so much!!! works perfectly!!

[Greg_Deckler]

Perhaps something like:

c_Index = DATEDIFF(MIN([Date]),[Date],DAY)+1

My have to reverse the first two parameters, I can never keep that straight...