Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Conditional Index Column Based on Date

Good day to you all   I am looking for some assistance in creating an index column called Trading Day No. based on the sorted date column. Index numbers should begin at 1 and all rows with the same...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Anonymous

     

    With DAX you can achieve the same with RANKX

     

    Add it as a calculated column

     

    Trading Day No. =
RANKX ( TableName, TableName[Date],, ASC, DENSE )
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

Please use the solution Zubair_Muhammad posted, it works successfully after test.

expected result
In addition, please mark the right reply as answer, so more members will get useful information or workaround easily.

Best Regards,
Angelia

vitalijusb_sisp's avatar
vitalijusb_sisp
Frequent Visitor
7 years ago

My problem is very similar, I need to numbering the records for each day. The numbering for each day starts anew, i.e. from 1. Could you help?

Thanks.

  • Aqila_Balqis's avatar
    Aqila_Balqis
    Frequent Visitor
    3 years ago
    Hello, did you find a way to create new numbering based on date? I also want to the same but not sure how