Forum Discussion
dax for conversion rate
Hi, I have a report with two different currencies, one is GBP(£) and the other is Euros. However when combined on power bi I want the total to be SEK = Swedish krona. How would this be ...
Hi that looks like its working for you
I've done this
SEK =
var selected_country = IF(ISFILTERED('Pipeline'[Country Name]), CONCATENATEX(CALCULATETABLE(VALUES('Pipeline'[Country Name])), 'Pipeline'[Country Name], ","), "")
return
IF(COUNTROWS(ALLSELECTED('Pipeline'[Country Name])) > 1, SUMX('Pipeline', 'Pipeline'[Financed Amount] * RELATED('Sheet1'[conversion_rate])),
IF(selected_country = "UK" , SUM('Pipeline'[Financed Amount]), SUM('Pipeline'[Financed Amount])
))
but when i click one country it still doesnt show me the value with out it being multiplied by conversion rate so the original number isnt shown
Hi Anonymous ,
Thejeswar 's formula works in my sample, you can compare the difference of my sample and yours, I attach it below. Analyzing where things went wrong can solve problems faster, or you can provide your sample without sensitive data, to let me know the difference.
Best Regards,
Community Support Team _ kalyj