create a calculated column based on other calculated column

[ashishN]

Hello , I'm looking to create a column..

date	no of apps
1	8
5	12
8	5
12	15
15	10

sum of no of apps = 50,

then need new colunm= sum of app - apps of perticuler date 

date	no of apps	new colmn
1	8	42
5	12	30
8	5	25
12	15	10
15	10	0

Any help is appriciated 

Thank you ,

AshihsN. 

[harshnathani · Accepted solution]

Hi @ashishN ,

Create a Calculated Column

Column = SUM('Table'[no of apps]) - 'Table'[no of apps]

or

Column 2 = SUM('Table'[no of apps]) - SUMx(FILTER('Table','Table'[date ] <= EARLIER('Table'[date ])),'Table'[no of apps]) 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)