Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Reverse Cummulative Sum

Hello All,   I need help with creating a column/measure in Power BI Desktop.   I want to create a reverse cumulative sum based on multiple columns below is the dataset(example):   The last colu...
cummulative dax
DAX
Desktop
power bi
ERD's avatar
ERD
Community Champion
5 years ago

Hello Anonymous ,

You can use this measure:

CummulativeQty = 
var currentId = SELECTEDVALUE('Table'[id])
var currentWH = SELECTEDVALUE('Table'[WH])
var currentCode = SELECTEDVALUE('Table'[Code])
var currentYear = SELECTEDVALUE('Table'[Year])
var currentMonth = SELECTEDVALUE('Table'[Month])
RETURN
CALCULATE(
    SUM('Table'[Qty]),
    FILTER(
        ALL('Table'),
        'Table'[id] = currentId &&
        'Table'[WH] = currentWH &&
        'Table'[Code] = currentCode &&
        'Table'[Year] = currentYear &&
        currentMonth <= 'Table'[Month]
    )
)

 

Did I answer your question? Mark my post as a solution!