Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
5 years ago
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...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    erhan_79 

    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:

     

     

  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    erhan_79 

    Good point! You can solve it for example by "inflating" the date expression: INT(table[Date]) * 100000000000000 + table[order number]

  • erhan_79's avatar
    erhan_79
    Post Prodigy
    5 years ago

    Dear richbenmintz 

     

    thanks for your support but i can not use Query side because this table is referenced   from a live connection.I need a dax formula to create a column on power bı desktop .your quide is tellinng about query solving.Is ıt possible thet you ca share with me DAX formula ?