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 )
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