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 ...
By combine I mean when my report slicer is selecting UK and Ireland which have different currencies how can I create an automatic dax measure which converts the two into SEK and adds them together
20 GBP
30 EU
246.54 - UK TO SEK
308.37 - EU TO SEK
TOTAL COMBINED = 554.91