Skip to main content
DD-TRF-003 Complex Joins, Exceptions and Transformation Logic Get the data →
DD-TRF-003-Q041 Hard

Monthly rates against a flat rate

Convert every row to SAR twice: with the rate of its month from MapCurrencyRates, and with the flat rates SAR 1, USD 3.75, AED 1.02. Report both totals and the difference.
Expected
Two totals and the difference by currency · Matrix
Tables
FactTransformationEvents, MapCurrencyRates · columns
  • FactTransformationEvents
  • MapCurrencyRates
  • Currency
  • TransactionDate
  • Amount
  • RateToSAR
  • YearMonth

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in