Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated column if a task repeats

Hi again folks.

I'm trying to create a calculated column in this table: 

KeySprint
D2C-176Sprint 08
D2C-176Sprint 09
D2C-391Sprint 10
D2C-391Sprint 11
D2C-545Sprint 11
D2C-545Sprint 13
D2C-635Sprint 10
D2C-635Sprint 12
D2C-635Sprint 13

 

that results in this

KeySprintRept
D2C-176Sprint 08 
D2C-176Sprint 091
D2C-391Sprint 10 
D2C-391Sprint 111
D2C-545Sprint 11 
D2C-545Sprint 131
D2C-635Sprint 10 
D2C-635Sprint 121
D2C-635Sprint 131

 

Can anyone help me?

 

TY guys

  • Anonymous's avatar
    Anonymous
    6 years ago

    You can try something like this:


    Rept = 
    VAR varKey = table[Key]  

    VAR varSprint = table[Sprint]

    VAR varSprintMin = 

        CALCULATE ( MIN ( table[Sprint] ), table[Key] = varKey )

    RETURN

    IF ( varSprint = varSprintMin, BLANK (), 1 )

     

    varKey saves current key as variable

    varSprint saves current sprint as variable

    varSprintMin calculates minimum of sprints for all rows with same key as current key

    return value: if current sprint is minimum of sprints with same key, returns BLANK, else 1

     

     

    -- editted for formating reasons

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    You can try something like this:


    Rept = 
    VAR varKey = table[Key]  

    VAR varSprint = table[Sprint]

    VAR varSprintMin = 

        CALCULATE ( MIN ( table[Sprint] ), table[Key] = varKey )

    RETURN

    IF ( varSprint = varSprintMin, BLANK (), 1 )

     

    varKey saves current key as variable

    varSprint saves current sprint as variable

    varSprintMin calculates minimum of sprints for all rows with same key as current key

    return value: if current sprint is minimum of sprints with same key, returns BLANK, else 1

     

     

    -- editted for formating reasons

  • Anonymous 

    Give this a try.

    Rept = 
    VAR _Key = 'YourTable'[Key]
    VAR _Sprint = 'YourTable'[Sprint]
    VAR _MinSprint =
        CALCULATE ( MIN ( 'YourTable'[Sprint] ), ALL ( 'YourTable' ), 'YourTable'[Key] = _Key )
    RETURN
        IF ( _Sprint = _MinSprint, BLANK (), 1 )