Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Averaging Exchange Rates for each Currency in a Custom Column

Hi,   I'm really hoping someone can help me here.   I have an Exchange Rate table which lists the currency rate for each currency  on a daily basis for a GBP conversion. This table links into the...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    You need to use and Aggregator formula in this case AVERAGEX. This will calculate the average based on each line of your table, you should use something similar to this:

    Average Rate = AVERAGEX('Exchange rates', 'Exchange rates' [Units per GBP])

     

    Be aware that this may not fit your model. If you need more assistance can you share a sample of your data please.

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

You need to use and Aggregator formula in this case AVERAGEX. This will calculate the average based on each line of your table, you should use something similar to this:

Average Rate = AVERAGEX('Exchange rates', 'Exchange rates' [Units per GBP])

 

Be aware that this may not fit your model. If you need more assistance can you share a sample of your data please.