Forum Discussion
Index Column that resets based on another column value
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
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
1 Reply
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