Add Local currency for every row, based on country code with Currency format

[Witold]

Hi, I need to have a different Currency for every row in one column Based on the country code or country. 

Right now I have a dax :

Revenue Local Currency =

CONCATENATE (

    IF (

        SELECTEDVALUE ( 'Table'[Currency] ) = "GBP", "£",

        IF ( SELECTEDVALUE ( 'Table'[Currency] ) = "USD", "$",

         IF ( SELECTEDVALUE ( 'Table'[Currency] ) = "JPY", "¥" ))

    ),

    CALCULATE (

        SUM ( 'Table'[Net Sale] ),

        FILTER (

            ALL ( 'Table' ),

            [Order Date] = MAX ( 'Table'[Order Date] )

                && [Country] = MAX ( 'Table'[Country] )

        )

    )

)

It works well but it works only as TEXT format, and I really keen to have as currency
Thanks in advance 

[lbendlin]

Text format is your only option at the moment.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com