Forum Discussion
Add Local currency for every row, based on country code with Currency format
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
Thanks in advance
1 Reply
- lbendlin
Super User
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
