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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.