Untitled

 avatar
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