Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ashishN
New Member

create a calculated column based on other calculated column

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

 

date no of apps
18
512
85
1215
1510

 

sum of no of apps = 50,

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

date no of appsnew colmn
1842
51230
8525
121510
15100

  

 

Any help is appriciated 

 

Thank you ,

AshihsN. 

1 ACCEPTED SOLUTION
harshnathani
Community Champion
Community Champion

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]) 

 

 

1.jpg

 

Regards,
Harsh Nathani

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

View solution in original post

1 REPLY 1
harshnathani
Community Champion
Community Champion

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]) 

 

 

1.jpg

 

Regards,
Harsh Nathani

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.