Hi!

I'm new in Power BI, and need some help with an issue with Salesforce data. The salesforce automaticaly convert the opportunity's amount to the current currency (in this case BRL), but when I got the data in Power BI, I don't see the amount converted, need to calculate between two tables (one with the amount, the currency and the close date, and other with the currency, the start date, the end date and the conversion rate), just like the images on links below.

https://ibb.co/FXmqxBm

https://ibb.co/HKK3F6G

https://ibb.co/hHVPp9t

How can I create a new colunm with the amount converted in the correct date? I know how to do this in Excel form (=@D:D(amount)/SE(@C:C(currency in the first table)="BRL";1;SOMASES(Planilha2!D:D(conversion rate);Planilha2!A:A(currency in table 2;@Planilha1!C:C(currency in table 1);Planilha2!B:B(start date);"<"&@Planilha1!E:E(close date);Planilha2!C:C(end date);">"&@Planilha1!E:E(close date)))

how can I use this logic in DAX?

Thank you,

Rebecca