Assign sequence based on Unique Values

[Anonymous]

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 Alabama:Alabama gets 1 but the two combination of Alabama:Birmingham both gets 2.   I think the best way would be to assign an index column that starts over at each change in Healthplan_Dashboard but I am not sure how to do that.

Market Split No	HealthPlan_Region	HealthPlan_Dashboard	Market Splits	GalaxySalesOffice
1	Southeast Region	Alabama	ALABAMA	ALABAMA
2	Southeast Region	Alabama	BIRMINGHAM	BIRMINGHAM
2	Southeast Region	Alabama	BIRMINGHAM	C. ALABAMA
3	Southeast Region	Alabama	HUNTSVILLE	HUNTSVILLE
3	Southeast Region	Alabama	HUNTSVILLE	NO. ALABAMA
3	Southeast Region	Alabama	HUNTSVILLE	NO.C ALABAMA
4	Southeast Region	Alabama	MOBILE	MOBILE
4	Southeast Region	Alabama	MOBILE	S. ALABAMA
5	Southeast Region	Alabama	MONTGOMERY	MONTGOMERY
1	West Region	Arizona	ARIZONA	ARIZONA
2	West Region	Arizona	PHOENIX	PHOENIX
3	West Region	Arizona	TUCSON	TUCSON
1	Southeast Region	Arkansas	LITTLE ROCK	LITTLE ROCK
1	Central Region	Central Texas	AUSTIN	AUSTIN
2	Central Region	Central Texas	SAN ANTONIO	SAN ANTONIO
1	Central Region	Cleveland	CLEVELAND	CLEVELAND
1	West Region	Colorado	COLORADO	COLORADO
2	West Region	Colorado	DENVER	DENVER
3	West Region	Colorado	WYOMING	WYOMING
1	Central Region	Columbus	COLUMBUS	COLUMBUS

[vanessafvg · Accepted solution]

@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

[Anonymous]

Perfect!  Thank you!