Format Column which has multiple currencies with correct currency symbol

Hi, Anonymous 

Maybe you can try the following methods.

Measure:

Measure = 
CONCATENATE (
    IF (
        SELECTEDVALUE ( 'Table'[Currency] ) = "GBP", "£",
        IF ( SELECTEDVALUE ( 'Table'[Currency] ) = "USD", "$" )
    ),
    CALCULATE (
        SUM ( 'Table'[Net Sale] ),
        FILTER (
            ALL ( 'Table' ),
            [Order Date] = MAX ( 'Table'[Order Date] )
                && [Country] = MAX ( 'Table'[Country] )
        )
    )
)

If a new currency appears, you can then write it in the IF function.

Best Regards,

Community Support Team _Charlotte

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