Forum Discussion
Currency conversion issue Sumx Issue
Hello community, Need help please, i'm atually working on a report who present for us the sales value by different slicers (country, category, date). what we have as an existing is two files on dri...
Hello dkozak
You already have the relationship between Sales and Rates Table using Key-Link-Sales so your measure can just use that.
Sales Amount € = SUMX ( Sales, Sales[Sales Value] * RELATED ( 'Rates Table'[Value] ) )
Hello jdbuchanan71 , but the rule of conversion is different.
The rule or the formula of calulation is like:
Sales(Euro) = calculate( divide(YTD Sales Month; Exchange rate Month) - Divide( YTD Sales Month - 1 ; Exchange rate Month -1))
Exampl for Sales (Euro)of February= calculate(Divide( YTD Sales february ; Exchange rate February) - Divide( YTD Sales Janyary ; Exchange Rate January))
Not sure I am following your example formulas. Given your sample data, could you fill in the last 2 columns in this table?
Country Date Sales Amount Value Expected_Result Formula RUSSIA 1/1/2019 28,325,732 76.3054545 RUSSIA 2/1/2019 10,624,860 75.5497 RUSSIA 3/1/2019 24,620,460 74.9093921 RUSSIA 4/1/2019 15,480,003 RUSSIA 5/1/2019 3,880,002 RUSSIA 6/1/2019 6,480,002 RUSSIA 7/1/2019 6,480,002 RUSSIA 8/1/2019 10,480,002 RUSSIA 9/1/2019 16,880,002 RUSSIA 10/1/2019 1,800,002 RUSSIA 11/1/2019 1,800,002 RUSSIA 12/1/2019 19,306,110
