Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |