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