Repetitive Indexing for certain IDs

[eliele]

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!

[Anonymous · Accepted solution]

@eliele There are several ways in which you can accomplish this. Check out this thread - > https://community.powerbi.com/t5/Desktop/Add-Index-Column-which-is-repeated-based-on-Group-by-Text-f...