Forum Discussion

Molin's avatar
Molin
Helper I
4 years ago
Solved

Currency Format

Dear Community,  I am working on a report where the users should be able to switch between 3 different currencies.  I have created a simple table (CurrencyMeasure) and the following DAX command...
Currency
DAX
Format
switch
  • johnt75's avatar
    johnt75
    4 years ago

    I think you should be able to use SELECTEDMEASUREFORMATSTRING() as the default in a SWITCH statement, so unless you explicitly specify a new format string for a measure it will use its original setting

johnt75's avatar
johnt75
Super User
4 years ago

You could use a field parameter. Create separate measures to return the value in the appropriate currency, each of which you can then format properly. Add all the measures to a field parameter and the user can choose between them.

Molin's avatar
Molin
Helper I
4 years ago

Hi johnt75, 

Thanks for the answer. The user should be able to change more then just the currency of Net Sales, also Buget and Forecast. Would that be possible using field parameter? I havent really played around with that feature yet. 

Thanks in advance. 

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    If there are multiple different types of measures to change then a fields parameter is probably not the best option, you might be better off with a calculation group as that would work with any measure you passed in to it, simply perform the currency conversion on the results of SELECTEDMEASURE(). It is also possible to have different format strings for different calculation items