Solved: Re: 2 different table correlation of 3 columns - Page 2

snifer · ‎01-07-2019

I need to find out how to find the right result for the two column exchange rate and avg.rate based on the match of column "month" "year" and "currency"


Economic						change in DKK

amount	currency	month	year			currency	month	year	exchange rate	avg. rate
10	EUR	1	2018			EUR	1	2018	1.5	1.3
20	CZK	2	2018			CZK	2	2018	7	7.5

result
amount	currency	month	year	exchange rate	avg. rate
10	EUR	1	2018	1.5	1.3
20	CZK	2	2018	7	7.5

AlB · ‎01-08-2019

@snifer

NewColumnExRate = 
LOOKUPVALUE (
    'change in DKK'[exchange rate],
   'change in DKK'[currency], 'Economic'[currency],
    'change in DKK'[month], 'Economic'[month],
    'change in DKK'[year], 'Economic'[year],
    'change in DKK'[source], "actual"
)

View solution in original post