Hi there,
I have a local currency, exchange rate and USD measures. Local currency / Exchange rate = USD.
On a year level it should not use the 17.60 as this is an average of the two months. The USD total for 2024 should be 158 221.99. Can someone please advise which function should I use to get to this?
Thank you.
Hi @Elmarie_Kies ,
In this case you need to do a different calculation use the following code:
USD = SUMX(SUMMARIZE('Table', 'Calendar'[Year], 'Calendar'[MonthNo]), CALCULATE(DIVIDE(SUM('Table'[Local]), AVERAGE('Table'[Echange Rate]))))I'm assuming you have a calendar table for the dates:
Don't mind the Exchange rate because using the column directly.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Hi @Elmarie_Kies ,
In this case you need to do a different calculation use the following code:
USD = SUMX(SUMMARIZE('Table', 'Calendar'[Year], 'Calendar'[MonthNo]), CALCULATE(DIVIDE(SUM('Table'[Local]), AVERAGE('Table'[Echange Rate]))))I'm assuming you have a calendar table for the dates:
Don't mind the Exchange rate because using the column directly.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
