Untitled

 avatar
unknown
plain_text
5 months ago
349 B
3
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