Forum Discussion

BHarm65's avatar
BHarm65
Frequent Visitor
3 years ago
Solved

Currency by Date

Hi,   I am working on a report which uses currency rates. The main goal of the report is to calculate the value of the interest of an entity with a currency in GBP or USD in EUR. The user must be...
Need Help
  • BHarm65's avatar
    BHarm65
    3 years ago

    Ok after a lot of testing I created a model that works.

    I created the relation between the Currencies table and the GenLedSetup and added a seperate date slicer to the table currencies with the option only to select one value.

    IF you select a date for the currencies it will give you only one result.

    This result can be used to calculate the value for the currency in the row.

     

    I also added the currency EUR to the currency table by creating in power query table with the currency rate 1 and appended it to the table currencies.

BHarm65's avatar
BHarm65
Frequent Visitor
3 years ago

Ok after a lot of testing I created a model that works.

I created the relation between the Currencies table and the GenLedSetup and added a seperate date slicer to the table currencies with the option only to select one value.

IF you select a date for the currencies it will give you only one result.

This result can be used to calculate the value for the currency in the row.

 

I also added the currency EUR to the currency table by creating in power query table with the currency rate 1 and appended it to the table currencies.