Trade premium

Great work so far. After benchmarking our prices, we know which loans we want to trade versus hold back. Now, we'll want to calculate the trade amount and trade premium amounts to understand how much money we'll make on these trades.

To do this, we'll need to multiply Price by the Scheduled Principal Balance. Both of these fields live in two separate tables that we haven't merged together. We can use the RELATED([column]) to call a value from another table.

More information on the syntax for RELATED() can be found here.

If you have lost progress, close any open workbooks and load 2_3_benchmarking_solution.pbix from the Exercises folder on the Desktop.