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.
This exercise is part of the course
Case Study: Mortgage Trading Analysis in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
