Forum Discussion
Giving Index Number
The solution I posted was for measures, not new calculated columns in the data table.
If you want to add these columns to the actual data table, you need:
1) New column concatenating date and order number
Concatenate date and order number = INT(INT('Table'[Delivery Date ]) & 'Table'[Order Number])2) New column for the index:
Index = RANKX ( FILTER ( ALL ( 'Table' ), 'Table'[Material] = EARLIER ( 'Table'[Material] ) ), 'Table'[Concatenate date and order number], , ASC )and you get this:
Good point! You can solve it for example by "inflating" the date expression: INT(table[Date]) * 100000000000000 + table[order number]
dear PaulDBrown ;
i noticed that when order number starts to be 4 digit , index calculating is working wrongly, as you see for below picture material C even has April delivery date index number coming=3
the reason is ; order umber "1000" because of being 4 digit making concateate column very big number
can we solve this issue ?
Good point! You can solve it for example by "inflating" the date expression: INT(table[Date]) * 100000000000000 + table[order number]
You are perfect PaulDBrown , really cool solution👏
erhan_79
nobody's perfect! But thank you for the compliment!Happy to have helped!