Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
Solved! Go to 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
Proud to be a Super User!
@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
Proud to be a Super User!
Perfect! Thank you!
User | Count |
---|---|
73 | |
70 | |
38 | |
23 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |