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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Nese_FZ
Helper I
Helper I

Accumulated balance

Hi

 

I am trying to create the accumulated balance by the launch date but it is not working.

 

I tested several formulas but it didn't work

 

Cold you helpe me please?

 

Acumulado dúvida.PNG

 

that´s I expected for

Acumulado dúvida_BASE.PNG

 

thanks in advance

2 REPLIES 2
amitchandak
Super User
Super User

@Nese_FZ , Use all of table, In place of Table[Date].

 

example

 

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(Sales),Sales[Sales Date] <=max(Sales[Sales Date])))
Cumm Sales = CALCULATE(SUM(Table[value]),filter(allselected(Table),Table[Date] <=max(Table[Date])))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Nese_FZ
Helper I
Helper I

Hi 

 

I tried all, but didn´t work. I solved it by introducing an index column and referencing it.

 

Anyway, thanks for your help!

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (27)