Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

currency display

i used this script to show what will be filtered, in particular, what currency will be displayed

 

Measure4display2Short =
IF (
SELECTEDVALUE ( CurrencySelector[value] ) = "Local Currency", UploadAccountsCurrentyPeriod[Company currency visualSHORT] ,"DKK")
 
 
since now I want to give the possibility to select more company I want to add the case where I select more company "UploadAccountsCurrentyPeriod[Company currency visualSHORT] and they have different currency(more than one) it will give as output "mixed currency""
Need Help
  • adityavighne's avatar
    adityavighne
    7 years ago

    Not possible with the same column with different currencies.

     

    create a new column with currency name and keep the original column with numbers only.

2 Replies

  • adityavighne's avatar
    adityavighne
    Continued Contributor
    7 years ago

    Not possible with the same column with different currencies.

     

    create a new column with currency name and keep the original column with numbers only.

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous ,

    Have you solved your problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please share some data sample which could reproduce your scenario and your desired output so that we could help further on it.

    Best  Regards,

    Cherry