How to perform calculation on fields from two different table which don't have any relationship

[a4]

Hi

I have two tables(quotedetails, spl_fixedratepremiumhistories).I want to multiply priceperunit(Quotedetails) to spl_baserate(spl_fixedratepremiumhistories). I have a Iso currency code field in common in both the tables. Conserding this field as a basis how can I multiply both the fields.

Please find the below screenshot attatched for better understanding

Any help is appreciated

Regards

Amit Kumar

[dax]

 Hi @a4 , 

If possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[a4]

Hi

Please find attatched below the screenshot for better understanding.

I want to multiply _baserate(_fixedratepremiumhistories) with priceperunit(quotedetails) depending on Iso currency code from both table. There is no direct relationship between these two table. These two tables are in relation with the third table transcationcurrencies. Please find the screnshot for better understanding.

Please suggest any possible solution.

Kind Regards

Amit Kumar