Add index relative to a time and a Job number. maybe RANKX

[vbourbeau]

Hi,

Look the exemple above, I want to add index relative to a time and a Job. Maybe in Dax RANKX or M I realy don't know.

Job     Time                                                           

B23    01:01:02

B23    01:01:25

B23    01:01:06

B28    01:01:25

B27    01:05:28

B27    01:05:30

WANT

Job     Time           Number                                                       

B23    01:01:02      1  

B23    01:01:25      3

B23    01:01:06      2

B28    01:01:25      1 

B27    01:05:28      1

B27    01:05:30      2

[vbourbeau · Accepted solution]

I use the solution here

https://community.powerbi.com/t5/Desktop/Add-calculated-index-column-by-DAX/td-p/72448