Line graph showing decrease in cumulative values as items are matured

[TRADER083]

Hi everyone, 

I have the following simplified raw data:

Maturity	Value
2050-Jan	1
2055-Dec	5
2060-Mar	2

I would like to create a measure and a line chart (or column) that present the following modified data:

Maturity	Value (sum where maturity is greater this date)
2050-Jan	8
2055-Dec	7
2060-Mar	2

Thank you,

[zenisekd · Accepted solution]

If you want to create a column, you can use: 

Value (sum where maturity is greater this date) = CALCULATE( SUM('YourTableName'[Value]), FILTER( 'YourTableName', 'YourTableName'[Maturity] >= EARLIER('YourTableName'[Maturity]) ) )

If you want a measure, then use: 
Value (sum where maturity is greater this date) = CALCULATE( SUM('YourTableName'[Value]), FILTER( ALL('YourTableName'), 'YourTableName'[Maturity] >= SELECTEDVALUE('YourTableName'[Maturity]) ) )

Kudos and mark as solution appreciated.

[ThxAlot · Accepted solution]

[TRADER083]

Thank you. For my dataset, the calculation on this measure was much faster than the other solution.

[zenisekd · Accepted solution]

If you want to create a column, you can use: 

Value (sum where maturity is greater this date) = CALCULATE( SUM('YourTableName'[Value]), FILTER( 'YourTableName', 'YourTableName'[Maturity] >= EARLIER('YourTableName'[Maturity]) ) )

If you want a measure, then use: 
Value (sum where maturity is greater this date) = CALCULATE( SUM('YourTableName'[Value]), FILTER( ALL('YourTableName'), 'YourTableName'[Maturity] >= SELECTEDVALUE('YourTableName'[Maturity]) ) )

Kudos and mark as solution appreciated.