Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |