Forum Discussion

Molin's avatar
Molin
Icon for Helper I rankHelper 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

Molin's avatar
Molin
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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