Converting to Foreign Currencies
I have a FORECAST table that has Qty, Product & Customer
A Product Table that has Product, Price in CURRENCY
An Exchange Rate Table with Currency & Date
I created a Measure Foreign Sales = Forecast Qty x Product Sell Price.
But when I try to convert foreign sales into NZD I get errors.
Despite watching numerous times the formulae still gives errors.
Probably beginners error but I am stumped
PBIX as attached