Multiple sources, single target: orders are in both EUR and USD, but the report must convert all currencies into USD.In this pattern, we cover three different scenarios where we simplified the description by only using EUR and USD: Finally, you might have both orders that are collected in different currencies and reports that need to show many different currencies. Alternatively, you might collect (or store) orders in a single currency, but need to report the values using different currencies. Indeed, you might collect orders in multiple currencies, but need to report on those orders using only one currency, so to be able to compare all the values with the same unit of measure.
There are two kinds of currencies: the currency used to collect orders and the currency used to produce the report. Currency conversion is a complex scenario where both the data model and the quality of the DAX code play an important role.
0 kommentar(er)
