My Azure board is organized in tasks. Each task has a complexity, effort and a ClosedDate. All data are organized in a Table
I need to create a DAX COLUMN with the cumulative sum of Complexity * Effort over ClosedDate and User
Example:
User | PBI Name | Effort | Complexity | Closed Date | CUMULATE |
---|---|---|---|---|---|
USERA | X1 | 1 | 2 | 2024/07/08 | 2 |
USERB | X2 | 2 | 3 | 2024/07/08 | 6 |
USERA | X3 | 1 | 4 | 2024/07/09 | 6 |
USERB | X4 | 2 | 4 | 2024/07/09 | 14 |
USERB | X5 | 3 | 1 | 2024/07/09 | 17 |
USERC | X6 | 1 | 1 | 2024/07/09 | 2 |
Cumulate =
VAR user = 'Table'[User]
VAR d = 'Table'[Closed Date]
VAR result = CALCULATE(SUMX('Table', 'Table'[Effort] * 'Table'[Complexity]), 'Table'[User] = user, 'Table'[Closed Date] <= d, REMOVEFILTERS())
RETURN result