Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Put below Measure in Card and you will get your answer...
Your Need=
SUMX(
SUMMARIZE(
'Table',
'Table'[Date],
"need",
POWER(
(CALCULATE(MAX('Table'[Value]),'Table'[Group] = "A") - CALCULATE(MAX('Table'[Value]),'Table'[Group] = "B")), 2)),
MAX([need]))
Thanks. I didn't think about using the SUMMARIZE function like that.
Put below Measure in Card and you will get your answer...
Your Need=
SUMX(
SUMMARIZE(
'Table',
'Table'[Date],
"need",
POWER(
(CALCULATE(MAX('Table'[Value]),'Table'[Group] = "A") - CALCULATE(MAX('Table'[Value]),'Table'[Group] = "B")), 2)),
MAX([need]))
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |