Hey,
Is there a way in Power BI to index a group of repetivie IDs?
For example, below is an illustarive dataset with Date, City, and State. I want to be able to index every time Florida (FL) appears, but if the earlier City was also in FL, then I don't want the index to change. I included a column with the desired outcome.
The reason I am asking this is because I want to be able to know if the location is currently in FL, and if it is in FL, how long it's been there. With the use of index, I can easily find the answer. If you think of a different solution, I would be more than happy to hear of an alternative answer rather than first indexing.
| Date | City | Sate | Desired Outcome |
| 5/22/2019 7:06 | Miami | FL | 1 |
| 5/22/2019 5:23 | Olrando | FL | 1 |
| 3/29/2019 2:28 | Jacksonville | FL | 1 |
| 2/23/2019 9:05 | Atlanta | GA | |
| 2/23/2019 9:05 | Los Angeles | CA | |
| 2/20/2019 2:56 | Miami | FL | 2 |
| 11/20/2018 9:54 | St. Louis | MO | |
| 11/19/2018 6:10 | Los Angeles | CA | |
| 8/21/2018 4:13 | Orlando | FL | 3 |
| 5/29/2018 5:02 | New York | NY | |
Thank you!
