Reply
rod_puente
Frequent Visitor
Partially syndicated - Outbound

Help! Accumulated amount

Community

 

Pls your help, I need a funtion with CALCULATE, that allows me to accumulate by product code.

This is an example, dates can be repeated: ...the formula should be like the yellow column.

 

rod_puente_0-1722981320803.png

 

Regards

Rodrigo P.

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

Syndicated - Outbound

@rod_puente 

you can create an index column in PQ

 

11.png

 

then use DAX to create a column

 

Column = sumx(FILTER('Table','Table'[Codigo Producto]=EARLIER('Table'[Codigo Producto])&&'Table'[Index]<=EARLIER('Table'[Index])),'Table'[Cantidad])
 
12.PNG
 
pls see the attachment below
 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
rod_puente
Frequent Visitor

Syndicated - Outbound

Excelent!

 

Tkns tm.

 

Regards

Rodrigo P

Syndicated - Outbound

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ryan_mayu
Super User
Super User

Syndicated - Outbound

@rod_puente 

you can create an index column in PQ

 

11.png

 

then use DAX to create a column

 

Column = sumx(FILTER('Table','Table'[Codigo Producto]=EARLIER('Table'[Codigo Producto])&&'Table'[Index]<=EARLIER('Table'[Index])),'Table'[Cantidad])
 
12.PNG
 
pls see the attachment below
 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)