Forum Discussion

marcura's avatar
marcura
Icon for Helper II rankHelper II
7 years ago
Solved

Change currency on column

Hello!   These are my columns, currently the values in this columns are Currency data type (BRL) Brazil actual currency.  'Budget Engineer'[Budget EST 2 Acumulado] 'Budget Engineer'[Budget 2019 M...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • marcura's avatar
    marcura
    7 years ago

    Hello and thanks for the quick response, but I already kill this problem with this:

     

     

    __Total Budget EST2 Monthly = IF(COUNTROWS(DISTINCT(ALLSELECTED('Currency'[Flag]))) < COUNTROWS(DISTINCT(ALL('Currency'[Flag])));SWITCH(TRUE();
[Selected currency]="EUR"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"€ 0,00");
[Selected currency]="USD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"U$ 0,00");
[Selected currency]="DKK"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"0,00 kr");
[Selected currency]="BRL"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"R$ 0,00");
[Selected currency]="CAD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"C$ 0,00");
[Selected currency]="CHF"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"0,00 fr");
[Selected currency]="GBP"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"£ 0,00");
[Selected currency]="AUD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"A$ 0,00");
FORMAT([_Total Budget 2019M];"R$ 0,00"));FORMAT([_Total Budget EST2M];"R$ 0,00"))
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi marcura ,

If I understand your requirement correctly, do you want to show the four columns based on the selected Currency?

For example, if you select DKK, the Budget Engineer'[Budget EST 2 Acumulado] should show the value as [Budget EST 2 Acumulado]*0.6058?

If so, I think you could create four measures like below to achieve that. You could modify it based on your scenario.

Measure =
CALCULATE (
    MAX ( 'Table'[Column1] ) * SELECTEDVALUE ( 'Table 2'[rate] ),
    FILTER (
        ALLSELECTED ( 'Table 2' ),
        'Table 2'[Currency] = SELECTEDVALUE ( 'Table 2'[Currency] )
    )
)

Here is my test output.

If you still need help, please share your data sample as table format and your desired output so that we could help further on it.

Best  Regards,

Cherry

 

marcura's avatar
marcura
Icon for Helper II rankHelper II
7 years ago

Hello and thanks for the quick response, but I already kill this problem with this:

 

 

__Total Budget EST2 Monthly = IF(COUNTROWS(DISTINCT(ALLSELECTED('Currency'[Flag]))) < COUNTROWS(DISTINCT(ALL('Currency'[Flag])));SWITCH(TRUE();
[Selected currency]="EUR"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"€ 0,00");
[Selected currency]="USD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"U$ 0,00");
[Selected currency]="DKK"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"0,00 kr");
[Selected currency]="BRL"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"R$ 0,00");
[Selected currency]="CAD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"C$ 0,00");
[Selected currency]="CHF"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"0,00 fr");
[Selected currency]="GBP"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"£ 0,00");
[Selected currency]="AUD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"A$ 0,00");
FORMAT([_Total Budget 2019M];"R$ 0,00"));FORMAT([_Total Budget EST2M];"R$ 0,00"))