Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Help! Accumulated amount
08-06-2024
03:00 PM
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.
Regards
Rodrigo P.
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-06-2024
05:54 PM

you can create an index column in PQ
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])
pls see the attachment below
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-07-2024
10:26 AM

Excelent!
Tkns tm.
Regards
Rodrigo P
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-21-2024
05:29 PM

you are welcome
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-06-2024
05:54 PM

you can create an index column in PQ
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])
pls see the attachment below
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 05-22-2024 02:34 PM | ||
07-03-2024 01:19 AM | |||
04-15-2024 04:01 AM | |||
03-08-2023 04:30 AM | |||
02-19-2021 10:43 AM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
90 | |
82 | |
57 | |
41 | |
39 |