Query with row values

Hi vpastor ,

1. In the power query editor, separate the TOTAL values.

2. Hold down the CTRL key and select all columns, inverse perspective columns.

3.Create measure.

Measure2 = 
VAR _vtable =
    FILTER (
        CROSSJOIN ( 'Table', 'Table2' ),
        FIND (
            FIXED ( 'Table2'[Value], 0, 2 ),
            FIXED ( 'Table'[GL Account No], 0, 2 ),
            ,
            BLANK ()
        )
            <> BLANK ()
    )
RETURN
    SUMX ( SUMMARIZE ( _vtable, [Amount], [GL Account No] ), [Amount] )

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.