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 |
| 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
- Anonymous6 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
- AnonymousNot 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
- jdbuchanan71Super User
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 )