Forum Discussion
Index for each group using DAX
Hi All,
I have a requiremet to get the idexes for each group of data.
Please find sample data below:
Note: We have other columns too in the actual data. this is only a sample data
| Protocol | Status | Date |
| A | Approved | 1/2/2022 |
| B | Open | 5/6/2022 |
| B | In Progress | 5/7/2022 |
| B | Closed | 5/8/2022 |
| C | In Progress | 5/7/2022 |
| C | Closed | 5/8/2022 |
| D | Exempt | 5/9/2023 |
Expected Output:
| Protocol | Status | Date | Index |
| A | Approved | 1/2/2022 | 1 |
| B | Open | 5/6/2022 | 1 |
| B | In Progress | 5/7/2022 | 2 |
| B | Closed | 5/8/2022 | 3 |
| C | In Progress | 5/7/2022 | 1 |
| C | Closed | 5/8/2022 | 2 |
| D | Exempt | 5/9/2023 | 1 |
Could somone pls let me know how to achieve this using DAX.
Thank you
2 Replies
If the Index is based on date, then you're basically looking for the count of items less than or equal to the current date for each Protocol.
This is the DAX I used:
Index = COUNTROWS(FILTER(ALL('Table'), 'Table'[Date] <= SELECTEDVALUE('Table'[Date]) && 'Table'[Protocol] = SELECTEDVALUE('Table'[Protocol])))
