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 | 3 |
| 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 |
Riccardo