Multiplying 3 columns

Hi Shilp1rin-gue,

I tried doing it using Calculated Column. Below is the data that I took.

Exchange Rate Table:

Transaction Table:

Assuming a relationship exists between the two tables, I created a calculated column in Transaction table as below:

This calculated column i.e. "Exchange_Rate" has value of "Exchange Rate" column from Exchange Rate table if Devise Reg is not MAD else it is 1.

Now, I created a measure using Price, Quantity and calculated column "Exchange_Rate" as below:

I hope this is what you were looking for.

Please mark this post as solution if it solved your purpose.

Thanks 🙂