Untitled
unknown
plain_text
5 months ago
1.0 kB
4
Indexable
Value Difference = SUMX( FILTER( CROSSJOIN( DISTINCT('Aggregated Value_SQL'[BMU]), DISTINCT('Aggregated Value_SQL'[Settlement Day]), DISTINCT('Aggregated Value_SQL'[Settlement Period]) ), NOT(ISBLANK([BMU])) ), VAR AggValue = CALCULATE( SUM('Aggregated Value_SQL'[+ve Agg Value]), 'Aggregated Value_SQL'[BMU] = EARLIER([BMU]), 'Aggregated Value_SQL'[Settlement Day] = EARLIER([Settlement Day]), 'Aggregated Value_SQL'[Settlement Period] = EARLIER([Settlement Period]) ) VAR GenSentOut = CALCULATE( SUM('QM & Generation sent out_SQL'[Generation Sent Out]), 'QM & Generation sent out_SQL'[BMU] = EARLIER([BMU]), 'QM & Generation sent out_SQL'[Settlement Day] = EARLIER([Settlement Day]), 'QM & Generation sent out_SQL'[Settlement Period] = EARLIER([Settlement Period]) ) RETURN ABS(AggValue - GenSentOut) )
Editor is loading...
Leave a Comment