Untitled
Anonymous
plain_text
11/27/2024 7:16 AM
468 B
10
Indexable
Value Difference (Aggregated) =
SUMX(
SUMMARIZE(
'Combined Table',
[Unified Key],
"AggValue", MAXX(FILTER('Combined Table', [Source] = "Aggregated"), [Value]),
"QMMeteredValue", MAXX(FILTER('Combined Table', [Source] = "QM-Metered"), [Value])
),
COALESCE([AggValue], 0) - COALESCE([QMMeteredValue], 0)
)
Editor is loading...
Leave a Comment