This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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!
Solved! Go to 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...
@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...
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 10 | |
| 9 | |
| 9 | |
| 9 | |
| 7 |
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 22 | |
| 21 | |
| 19 |