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.
|2/23/2019 9:05||Atlanta||GA|| |
|2/23/2019 9:05||Los Angeles||CA|| |
|11/20/2018 9:54||St. Louis||MO|| |
|11/19/2018 6:10||Los Angeles||CA|| |
|5/29/2018 5:02||New York||NY|| |