Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Can anybody refer to me what formula I need to use to calculate the cumulative sales total within this table? I am having trouble doing so
Solved! Go to Solution.
@cdawidow
You need to have a column like dates or any category that is related to each line where you can do the accumulation?
This would be that formula and needs to be adjusted. You share some table with dummy data.
CALCULATE ( SUM ( TableName[Sales Amount] ), FILTER ( ALL( TableName), TableName[Date] <= EARLIER ( TableName[DATE] ) ) ),
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@cdawidow Not very clear.
Do you want to obtain cumulative sales based on sales rank?
i.e. 1, 1+2, 1+2+3 ....
@cdawidow Not very clear.
Do you want to obtain cumulative sales based on sales rank?
i.e. 1, 1+2, 1+2+3 ....
@cdawidow
You need to have a column like dates or any category that is related to each line where you can do the accumulation?
This would be that formula and needs to be adjusted. You share some table with dummy data.
CALCULATE ( SUM ( TableName[Sales Amount] ), FILTER ( ALL( TableName), TableName[Date] <= EARLIER ( TableName[DATE] ) ) ),
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @cdawidow ,
Not very clear but you can try this.
You can try this measure
RRT =
VAR _rankval =
MAX ( 'Table'[SalesRank] )
RETURN
CALCULATE (
SUM ( 'Table'[Total Sales] ),
'Table'[SalesRank] <= _rankval
)
Incase this does not work share the sample data in text format and required output.
Regards,
Harsh Nathani
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
61 | |
50 | |
45 | |
20 | |
17 |