Hello, I'm currently setting up a data model for monthly reporting where I need to convert the figures from foreign currency to EUR. However, it works fine on total level but does not show the correct figures on deepest level.
: Sales_Cond = fact table Calendar = calendar Exchange_Rate = table with dates and exchange rates from foreign currency to EUR Currency = distinct currencies (USD, GBP, DKK, etc.)
Filter in output: e.g. Month = 6; Year = 2021; Country = Denmark
Formula: Turnover YTD current year (EUR):=
CALCULATE(SUM(Sales_Cond[Turnover value (LC)]);Sales_Cond[Customer]="ZLBO";DATESYTD('Calendar'[Date];"12/31"))*-1;