Currency Calculation

[Arnaud31450]

Hi everyone,

I have values in the table "Fact Sales Actual" stored as US dollar in "sales_$fxb" e.g. 1,000 (field is summarized)

In this table I have "skey_business_entity_sold_to" e.g. France

In another Table "dim Solt to" I have values "skey_business_entity_sold_to" e.g. France

This table is linked to "Fact Sales Actual" via "skey_business_entity_sold_to" via 1 to many and filters fact actual sales

In another Table "Dim Country to Currency" I have values "sold-to Country" e.g. France; "Currency" e.g. EUR; "Fxb Rate 2022" e.g. 1.2; 

This table is linked to "dim Sold to" via "sold-to Country" (also in "dim Sold to")

I would like to create a new measure which is "Sales_Curr_Fxb22" that takes "skey_business_entity_sold_to" check its "Currency" and divide "sales_$fxb" by "Fxb Rate 2022" corresponding value based on "Currency"

Thanks for the help.

[Arnaud31450]

Solved with data integration.

[bcdobbs]

Have you read Currency conversion – DAX Patterns? I think it's what you're looking for.

[Arnaud31450 · Accepted solution]

Hi @bcdobbs ,

Yes I did but couldn't figure out the formula due to the extra table linkage, somehow I am doing something wrong, so trying to learn based on others input 😕