How to handle different currencies in one column

[Anonymous]

Hi,

having a problem with a revenue column which includes different currencies.

I can identify the once which are not in EUR with column Sales Line.

My idea is to use exchange rates with a condition on Sales line when to use which exchange rate and for the rest jsut multiplied by 1.

Can someone please help me with that formula. 

Thanks

Lina

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Please try the v-shex-msft's suggestion in this link: http://community.powerbi.com/t5/Desktop/IF-statement-with-SUM/td-p/70552

If it doesn't meet your requirement, please share some sample data and expected results for our analysis.

Best Regards,
Qiuyun Yu