topic Re: Help needed: Measure to return a cumulative (i.e. running) sum for a calculated column in DAX Commands and Tips

Help needed: Measure to return a cumulative (i.e. running) sum for a calculated column

simonm8008 — Tue, 09 Aug 2022 07:55:21 GMT

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 Cumulative) based on Planned. However, the existing Planned Cumulative is not the Expected Result:

I have the following measures:

Planned =

VAR Sprint = [Sprint]

VAR MAXDate = MAX('Current PI - All User Stories'[Date])

RETURN

IF(MAXDate >= [Date],BLANK(),

CALCULATE(

SUM('Current PI - All User Stories'[Story Points]),

'Current PI - All User Stories'[Date] = MAXDate, 'Current PI - All User Stories'[Sprint] IN { Sprint })

)

Planned Cumulative =

CALCULATE(

SUM('Burnup Data'[Planned]),

FILTER(

ALL('Burnup Data'),

'Burnup Data'[Date] <= MAX('Burnup Data'[Date])

)

Any help would be greatly appreciated!

Re: Help needed: Measure to return a cumulative (i.e. running) sum for a calculated column

ribisht17 — Tue, 09 Aug 2022 09:33:59 GMT

simonm8008

Please check this post Solved: Cumulative Sum using DAX - Microsoft Power BI Community

Thanks,

Ritesh

Re: Help needed: Measure to return a cumulative (i.e. running) sum for a calculated column

memepu — Thu, 11 Aug 2022 05:35:31 GMT

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.