Forum Discussion

s2j6's avatar
s2j6
New Member
6 years ago

Cumulative

Hello,   I am new to BI and read as many posts and tutorials but unable to provide  a new measure to provide cumulative totals per month.  Table consists of "Create Date" and "Length of Installe Pi...
Need Help
az38's avatar
az38
Community Champion
6 years ago

Hi s2j6 

if you need a column try

Column = CALCULATE( SUM(Table[Length of Installe Pipe]), FILTER(ALL(Table), Table[Create Date] <= EARLIER(Table[Create Date]) ) )

if you need a measure try

Measure = 
CALCULATE( SUM(Table[Length of Installe Pipe]), FILTER(ALL(Table), Table[Create Date] <= SELECTEDVALUE(Table[Create Date]) ) )