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]
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:
Thank you very much PaulDBrown , this is what i needed .