Forum Discussion
Running Total
Hello All, Please help me with this. Revenue is a Default meausre from SQL server source. I calulated Revenue Contribution(Measure) as DIVIDE(SUM(Query1[Revenue]),[Total Revenue],0) then after so...
I wrote a blog post today about how to create a Pareto Cumulative Running Total
http://exceleratorbi.com.au/cumulative-running-total-based-on-highest-value/
Hi jahida,
I got this error when i use the formula you gave;
Error Message:
MdxScript(Model) (1, 199) Calculation error in measure 'PYQueryActual'[GS_RunningTotalPY]: Min or Max of booleans or strings are not currently supported.
Stack Trace:
Invocation Stack Trace:
Activity ID
23b334aa-8351-dda4-5704-77193dcda03e
Time
Mon Aug 15 2016 16:41:04 GMT+0530 (India Standard Time)
Version
2.37.4464.361 (PBIDesktop)
Error Code
rsDataShapeProcessingError
OData Error Message
Failed to execute the query.
Paste in the exact formula you tried..?