Hello Forum. I have a POWERPIVOT for EXCEL report that shows total spent by project. I tried to create a DAX measure showing the running total by project so that i can show Cumulative spent however the running total does not work . My model is very simple and consist in 1 fact and 1 dimension table. See attached.
Any help is greatly appreciated. Thanks in advance
powerpivotreport.xlsx (2.4 MB)
@jazzista1967 See if this helps:
Thanks AntrikshSharma. However, like i stated in the message, I am using powerpivot for excel and there are some formulas that are not available in PP
@jazzista1967 Except for ISINSCOPE, All of the other functions I have used in the blog are available in Power Pivot, which one are you referring to? Are you using an old version of Excel?
I am using powerpivot for excel and my excel version is excel 365. This is the formula that i am using and it is not returning the cumulative amount. Please take a look at data the model ( It is very simple: It only contains one fact and one dimension table. The table with the results is highlighted in yellow and it is on the third tab called Projects running totals. Thanks in advance
SUMX (
FILTER (
SUMMARIZE (
ALLSELECTED ( AbandonmentAFES ),
AbandonmentAFES[AFE_Code],
“Cost”, [Total AFE Net Cantium]
),
[Cost] >= [Total AFE Net Cantium]
),
[Cost]
)
Bumping this post for more visibility.
Hi @Jazzista1967! We noticed that your inquiry was left unsolved for quite some time now. We strive to answer ALL inquiries in the forum.
However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.
While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!
No . this was never resolved. I provided the formula that i used to create the running total pattern however the formula returns the wrong results:. I am using powerpivot for excel (Office 365) NOT powerbi. and it is a simple one fact table and one dimension table. Thanks in advance if somebody could tell me what i am doing wrong and how I could fix the formula to obtain the correct running totals
SUMX (
FILTER (
SUMMARIZE (
ALLSELECTED ( AbandonmentAFES ),
AbandonmentAFES[AFE_Code],
“Cost”, [Total AFE Net Cantium]
),
[Cost] >= [Total AFE Net Cantium]
),
[Cost]
)
Hello Antriksh,
The Running Total function over text values becomes even more interesting if there’re multiple Brands with the exact same values.
Please have a look at this example with a small change - two new Brands (Company A, Company B) with same Total Sales (500k) have been added. In that case, our Running Total doesn’t recognize the increments from identical values, it simply repeats them instead of adding them up.
Is there any workaround for this issue**?** Thank you so much for a solution. Best regards, Rafal
The measure I used is as follows:
RT Brands =
VAR CurrentBrandSales = [Total Sales]
RETURN
SUMX(
FILTER(
SUMMARIZE( ALLSELECTED( fSales ), dBrands[Brand ID],
“@Sales”, [Total Sales] ),
[@Sales] >= CurrentBrandSales ),
[@Sales] )
Hello everyone,
Can someone please help me with my question I posted here a week ago - why increments of identical values counted on non-numeric fields are repeated insteas of being added up (wouldn’t be any issue with running total over days) ??
Your help is greatly appreciated - please see my photo of dataset (the same used by jazzista1967) in my previous post here.
HI @RafalM
You might want to start a new topic as you added on to another topic that has already been solved. This is the possibility why no one has replied to your issue. People in the forum don’t look at topics that are already been solved.
Also, addressing to certain person within the forum isn’t allowed as it discourage others within the forum to address your issue.
Please start a topic and you will likely get results faster.
thanks
Keith
