Forum Discussion
Solved
Giving Index Number
Hi The most powerful ad helper community 🙂 i need your kind supports to create a column.let me explain what i need pls : I have table as below , wtih the named columns : "material" , "Orde...
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]
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!