Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Assign sequence based on Unique Values

I have the following list.  I need to assign the "Market Split No" column but assigning a sequence based on the unique combination of Healthplan_Dashboard and Market Splits.  So the combination of Al...
  • vanessafvg's avatar
    7 years ago

    Anonymous 

     

    would this work?

     

    i created a duplicated table, removed duplicates and created a index based on the composite columns and then merged that back in with a column called index

     

    see pbix attached