Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise