cancel
Showing results for
Did you mean:
Helper I

## Cumulative of (Value^2)

Hello,

I have a question to calculate running sum of a formula.

I have a table

I want to calculate the running sum of (Value^2).

I expect to have for each row:

(7^2) = 49

(7^2) + (1^2) = 50

(7^2) + (1^2) + (2^2) = 54

I tried to do it in DAX

``````Measure 5 =
CALCULATE (
SUM (Master[Value]) * SUM (Master[Value]),
FILTER (
ALL ( Master ),
Master[Date] <= MAX ( Master[Date] )
)
)``````

But the result is

Anyone can help me for the correct DAX to get 49, 50, and 54 as the running sum?

Any help will be greatly appreciated! Thank you.

1 ACCEPTED SOLUTION
Super User IV

@gggar

Use the formula this way:

``````Value Measure =
var _date =  MAX(Master[Date]) return
CALCULATE(
SUMX(VALUES(Master), Master[Value] * Master[Value]),
Master[Date] <=_date
)``````

Did I answer your question? Mark my post as a solution! and hit thumbs up

2 REPLIES 2
Helper I

@Fowmy , thanks a lot!

Super User IV

@gggar

Use the formula this way:

``````Value Measure =
var _date =  MAX(Master[Date]) return
CALCULATE(
SUMX(VALUES(Master), Master[Value] * Master[Value]),
Master[Date] <=_date
)``````

Did I answer your question? Mark my post as a solution! and hit thumbs up

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.