Creating New Table with SUMPRODUCT from Existing Tables

Question

I have 2 separate tables (PmtTable, RateTable) that I'd like to use to create a new table (NewTable) that has a SUMPRODUCT calculation that is derived using the two original tables.&nbsp; Using Excel it would look something like this:&nbsp; &nbsp;=SUMPRODUCT('RateTable'[A:A], 'RateTable'[E:E], 'PmtTable'[E:E] / SUMPRODUCT('RateTable'[A:A],&nbsp;'PmtTable'[E:E])&nbsp;RateTable&nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ETermRate_012Rate_024Rate_036Rate_0481.05438.051989.050373.049672.05318.052763.055737.04896&nbsp;PmtTable&nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ETermRate_012Rate_024Rate_036Rate_048181441397042580418862281780398702591119273&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
There seems to be something wrong with the code you provided, and I don't quite understand what you need.
&nbsp;
If you can, please provide some dummy data and desired results. It is best presented in table form.
&nbsp;
Regards,
Nono Chen

Forum Discussion

Creating New Table with SUMPRODUCT from Existing Tables

1 Reply

Related content

Cannot create liquid clustering on existing unpartitioned table

Create Data Pipeline with existing definition using Terraform

SumProduct in measure

SUMPRODUCT

SumProduct Between two Table Values

Term	Rate_012	Rate_024	Rate_036	Rate_048
1	.05438	.051989	.050373	.04967
2	.05318	.052763	.055737	.04896

Term	Rate_012	Rate_024	Rate_036	Rate_048
1	81441	39704	25804	18862
2	81780	39870	25911	19273