Forum Discussion
Calculated column if a task repeats
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...
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 )