Untitled
unknown
plain_text
a year ago
349 B
5
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