Forum Discussion
Helper IIChange 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 Monthly]
'Budget Engineer'[Budget 2019 Acumulado]
'Budget Engineer'[Budget EST 2 Monthly]
I have another table 'Currency' without any table connections, with:
I need to when one of those flags is selected (i already have the currency rate of the selected currency in a calculated measure) the values on the 4 columns in 'Budget Engineer' change.
Also the 'Currency' is represented in my dashboard as:
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"))
2 Replies
v-piga-msftResident Rockstar
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
marcuraHello 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"))