Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |