There's more...

We can compare the difference between simple interest and compound interest by doing the following:

1. Create a measure using the following formula:

Simple Interest = [Principal] * [Interest Rate] * [Periods]

2. On the same Report page, create a Card visualization and place the Simple Interest measure into the Fields area for the visualization.

Observe that the simple interest that's earned over the same period is only $50,000.