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

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
Helper I
4 years ago

Hi, 

Thanks a million. I got it solved with the SELECTEDMEASUREFORMATSTRING()