Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Currency conversion with dates from Salesforce Data

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...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    In case anyone look for this answer, I got it...

     

    Amount converted = CALCULATE(sum(Oportunidade[ValorTotalContrato__c])/
    SUM('Taxa de conversão datada'[ConversionRate]);
    FILTER('Taxa de conversão datada';Oportunidade[CurrencyIsoCode]='Taxa de conversão datada'[IsoCode]);
    FILTER('Taxa de conversão datada';Oportunidade[CloseDate]>='Taxa de conversão datada'[StartDate]&&Oportunidade[CloseDate]<'Taxa de conversão datada'[NextStartDate]))

     

    🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

In case anyone look for this answer, I got it...

 

Amount converted = CALCULATE(sum(Oportunidade[ValorTotalContrato__c])/
SUM('Taxa de conversão datada'[ConversionRate]);
FILTER('Taxa de conversão datada';Oportunidade[CurrencyIsoCode]='Taxa de conversão datada'[IsoCode]);
FILTER('Taxa de conversão datada';Oportunidade[CloseDate]>='Taxa de conversão datada'[StartDate]&&Oportunidade[CloseDate]<'Taxa de conversão datada'[NextStartDate]))

 

🙂

  • omar___sherif's avatar
    omar___sherif
    Frequent Visitor
    4 years ago

    Ok, so this is working, but whenever i try to perform any operation or use this 'Amount Converted' field in any other dax expression i get ' a circular dependancy was detected' error.

    Any idea how to solve this issue?

     

    Thanks