Forum Discussion

Mateusz00's avatar
Mateusz00
Frequent Visitor
2 years ago
Solved

Index / Rank

Hello, I have three columns (ID, Time and Status). I would like to have some calculated column which shows me for each ID index / rank until the status is "Closed" (based on time column). ID      ...
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, Mateusz00 

    try below code 

    RANKX(
    FILTER(
        'Table','Table'[id]=EARLIER('Table'[id]) &&
        'Table'[time]<=EARLIER('Table'[time])&&
        'Table'[status]="closed"
    ),
    'Table'[time],,ASC,Dense
)

     

     

Mateusz00's avatar
Mateusz00
Frequent Visitor
2 years ago

Hello, thank you for your response but how can we complete each rows? (in this formula we have blanks and I must have data exactly like in my Index column from the sample).

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, Mateusz00 

try below code 

RANKX(
    FILTER(
        'Table','Table'[id]=EARLIER('Table'[id]) &&
        'Table'[time]<=EARLIER('Table'[time])&&
        'Table'[status]="closed"
    ),
    'Table'[time],,ASC,Dense
)