FX conversion with YTD amounts

Hi petar_kisdobran ,

Maybe you can try this:

Measure =
VAR _s =
    SUMMARIZE( 'Table', 'Table'[Month], 'Table'[Entity] )
VAR _a =
    ADDCOLUMNS(
        _s,
        "sum",
            DIVIDE(
                CALCULATE(
                    SUM( 'Table'[Amount (local currency)] ),
                    FILTER(
                        ALL( 'Table' ),
                        [Entity] = EARLIER( 'Table'[Entity] )
                            && [Month] <= EARLIER( 'Table'[Month] )
                    )
                ),
                CALCULATE(
                    MAX( 'Table'[fx rate] ),
                    FILTER(
                        ALL( 'Table' ),
                        [Entity] = EARLIER( 'Table'[Entity] )
                            && [Month] = EARLIER( 'Table'[Month] )
                    )
                )
            )
    )
RETURN
    SUMX( _a, [sum] )

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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