I'm implementing a currency conversion in a tabular model. It works, however it is too slow.
I have a "Report Currency"-table with date,[currency code] and rate columns, where the rate is the Exchange rate between the currency and my base currency (EUR).
In my fact table I have an order date that determines which rate to use.
I show the currency column in the client Tools (i.e. Excel). The user then filters the currency code for example choosing "USD" as currency. The measure, for example "Line Amount (Report Currency)" is then shown in USD.
I have tried the following DAX-expressions for the measure:
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.