Forum Discussion
Index Help
Hi all, I have loads of data and I want to create an index in power that restarts at each team. I want the lastest date to be 1 and then each date after increment by 1, the table below is how I would want the index to work
| Index | Date | Team |
| 1 | 10/01/2020 | Three |
| 2 | 05/01/2020 | Three |
| 3 | 01/01/2020 | Three |
| 4 | 07/01/2020 | Three |
| 1 | 06/01/2020 | Two |
| 2 | 04/01/2020 | Two |
| 3 | 01/01/2020 | Two |
| 1 | 03/01/2020 | One |
| 2 | 02/01/2020 | One |
| 3 | 01/01/2020 | One |
I think rank should help you.
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finaleAppreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin
2 Replies
I think rank should help you.
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finaleAppreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin
