Index Column that resets based on another column value

[Anonymous]

In this example, the index resets when the location changes.  Here is the example below:

City	Index	WhatIndexShouldBe
New York	1	1
New York	2	2
New York	3	3
London	4	1
London	5	2
London	6	3
London	7	4
London	8	5
London	9	6
Chicago	10	1
Chicago	11	2
Chicago	12	3
Boston	13	1
Boston	14	2
Boston	15	3
Boston	16	4
Boston	17	5
Boston	18	6

Thanks in advanced!

-Ryan Mulhollem

[Anonymous · Accepted solution]

These links should solve your problem I think:

https://community.powerbi.com/t5/Desktop/Custom-column-Index-or-Ranking-by-other-column/td-p/33864

https://community.powerbi.com/t5/Desktop/Add-calculated-index-column-by-DAX/td-p/72448

The first one has a video that is very straightforward.

Michelle