powerbidaxdata-analysispowerbi-desktopmeasure

POWERBI - DAX - RunningTotal


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

Solution

  • 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