Untitled
unknown
plain_text
5 months ago
536 B
3
Indexable
Value Difference = SUMX( DISTINCT(UNION( VALUES('Aggregated Value_SQL'[BMU]), VALUES('QM & Generation sent out_SQL'[BMU]) )), VAR AggValue = CALCULATE( SUM('Aggregated Value_SQL'[+ve Agg Value]), 'Aggregated Value_SQL'[BMU] = EARLIER('Aggregated Value_SQL'[BMU]) ) VAR GenSentOut = CALCULATE( SUM('QM & Generation sent out_SQL'[Generation Sent Out]), 'QM & Generation sent out_SQL'[BMU] = EARLIER('Aggregated Value_SQL'[BMU]) ) RETURN AggValue - GenSentOut )
Editor is loading...
Leave a Comment