topic Currency Calculation in DAX Commands and Tips

Currency Calculation

Arnaud31450 — Tue, 14 Dec 2021 16:08:23 GMT

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.

Re: Currency Calculation

bcdobbs — Tue, 14 Dec 2021 08:40:13 GMT

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

Re: Currency Calculation

Arnaud31450 — Tue, 14 Dec 2021 08:41:49 GMT

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 😕

Re: Currency Calculation

Arnaud31450 — Wed, 15 Dec 2021 08:54:21 GMT

Solved with data integration.