Forum Discussion
Solved
Help needed: Measure to return a cumulative (i.e. running) sum for a calculated column
Hello Fairly new to Power BI, so there's probably a simple solution for my problem! I have the following table ('Burnup Data') where I am trying to calculate a running total (Planned Cumulati...
Hi simonm8008 ,
I have created a simple sample, please refer to it to see if it helps you.
sum for a calculated column.pbix
Create a measure.
Measure = CALCULATE ( SUM ( 'Table'[Planned] ), FILTER ( ALL ( 'Table' ), 'Table'[date] <= SELECTEDVALUE ( 'Table'[date] ) ) )If the planed column is written by a measure.
Please have a try.
Measure 2 = SUMX(FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])),[Planned_])If I have misunderstood your meaning, you can create simple data with excel, then show me the screenshots about the data and the desired output your want.
Best regards.
memepu
Resolver II
Resolver IIHi simonm8008 ,
I have created a simple sample, please refer to it to see if it helps you.
sum for a calculated column.pbix
Create a measure.
Measure =
CALCULATE (
SUM ( 'Table'[Planned] ),
FILTER ( ALL ( 'Table' ), 'Table'[date] <= SELECTEDVALUE ( 'Table'[date] ) )
)If the planed column is written by a measure.
Please have a try.
Measure 2 = SUMX(FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])),[Planned_])If I have misunderstood your meaning, you can create simple data with excel, then show me the screenshots about the data and the desired output your want.
Best regards.