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
rfigtree's avatar
rfigtree
Resolver III
5 years ago

or calculated column with similar formula.

=CALCULATE(SUM(Table1[qty]),
	filter(Table1,
	Table1[id]=EARLIER(Table1[id]) && 
	Table1[wh]=EARLIER(Table1[wh]) && 
	Table1[code]=EARLIER(Table1[code]) && 
	Table1[year]=EARLIER(Table1[year]) && 
	Table1[month]>=EARLIER(Table1[month])
	))