Squaring & Adding Values from Different Rows Within the Same Column

Question

The problem can best be described with an example below:

Table1:
Date | group | Value

1/1/2000 | A | 10

1/1/2000 | B | 5

1/2/2000 | A | 11

1/2/2000 | B | 7

I would like to calculate the sum of the squared difference for each date between groups A and B. For the example above, it would be (10-5)^2 + (11-7)^2.

Any help greatly appreciated. Thanks.

ddpl · Accepted Answer

qngu&nbsp;&nbsp;Put below Measure in Card and you will get your answer...&nbsp;Your Need= SUMX(&nbsp; &nbsp;SUMMARIZE(&nbsp; &nbsp; &nbsp; 'Table',&nbsp; &nbsp; &nbsp; 'Table'[Date],&nbsp; &nbsp; &nbsp; "need",&nbsp; &nbsp; &nbsp; POWER(&nbsp; &nbsp; &nbsp; (CALCULATE(MAX('Table'[Value]),'Table'[Group] = "A") - CALCULATE(MAX('Table'[Value]),'Table'[Group] = "B")), 2)),&nbsp;MAX([need]))

Forum Discussion

Squaring & Adding Values from Different Rows Within the Same Column

2 Replies

Related content

Adding columns

Different schema into different destination

RSCustomDaxFilter column name with square brackets

Square Matrix

Adding a column