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
)`````` Proud to be a Super User!

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
)`````` Proud to be a Super User! Announcements #### Welcome to the User Group Public Preview  