Untitled
unknown
plain_text
5 months ago
691 B
3
Indexable
Combined Table = NATURALLEFTOUTERJOIN( SELECTCOLUMNS( 'Aggregated Value_SQL', "Settlement Day", 'Aggregated Value_SQL'[Settlement Day], "Settlement Period", 'Aggregated Value_SQL'[Settlement Period], "BMU", 'Aggregated Value_SQL'[BMU], "AggValue", 'Aggregated Value_SQL'[Aggregated Value] ), SELECTCOLUMNS( 'QM & Generation sent out_SQL', "Settlement Day", 'QM & Generation sent out_SQL'[Settlement Day], "Settlement Period", 'QM & Generation sent out_SQL'[Settlement Period], "BMU", 'QM & Generation sent out_SQL'[BMU], "QMMeteredVolume", 'QM & Generation sent out_SQL'[QM-Metered Volume] ) )
Editor is loading...
Leave a Comment