Calculated column if a task repeats

[Anonymous]

Hi again folks.

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

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

that results in this

Key	Sprint	Rept
D2C-176	Sprint 08
D2C-176	Sprint 09	1
D2C-391	Sprint 10
D2C-391	Sprint 11	1
D2C-545	Sprint 11
D2C-545	Sprint 13	1
D2C-635	Sprint 10
D2C-635	Sprint 12	1
D2C-635	Sprint 13	1

Can anyone help me?

TY guys

[jdbuchanan71]

@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 )

[Anonymous · Accepted solution]

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