Forum Discussion

Hamdan1234's avatar
Hamdan1234
Icon for Helper III rankHelper III
4 years ago

Excel Formula Replication

I have got two tables in two sheets  and I have used Sumifs formula in excel to get a new column on the basis of both the tables.Tables are: Month Curr Conversion Rate Jan AUD 0.769823 ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

Hamdan1234 Try:

Currency Conversion Outcome (Column) =
  VAR __Month = [Month]
  VAR __DocumentCurrency = [Document Currency]
  VAR __ConversionRate = MAXX(FILTER('OtherTable',[Month]=__Month && [Curr]=__DocumentCurrency),[ConversionRate])
RETURN
  __ConversionRate