DAX question - FX calculation aggregated

[MartinSDR]

Hi!

I am new to DAX(M) and PowerBI and would very much appreciate if someone could guide me in the right direction for the following issue:

1. I have 3 different General Ledgers with 3 different Currencies, 

2. I have another table with the currency exchange rates per month.

3. I have a date table.

All the tables have been normalized and set up with correct connections/relations

My task is to create a measure that would show the aggregated sum of the converted amounts. 

If I show the values per say February, the measure would show the sums of [J(anuary * FX Jan) + (February * FX Feb)]

I realize that i could add a calculated columns to all the GeneralLedgers per month and multiply the sums with that months exchange rate and then to a simple calculate(sum)) function for the measure.

I am looking for a cleaner solution only using a measure to do the job!

Any hint of what to do would be very helpful! 

Thanks!

[Greg_Deckler · Accepted solution]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, it likely involves the CALCULATE and RELATEDTABLE functions or else perhaps a combination of SUMMARIZE, ADDCOLUMNS and SUMX.