This lesson's interactive features are locked, please to keep using them

Handle Discounts

Our new price calculated column has a slight problem... it represents the price before discounts are applied!

Let's add a new discounted_price column that accounts for them.

Assignment

Select the sales table, then click on "New column" in the top ribbon.
Write a formula that calculates the discounted_price and save it. I'm not going to give you the syntax to copy/paste, but the formula should be:
```
Full Price * (1 - Discount Amount)
```
When you start typing the table name in the formula input, Power BI helpfully autocompletes column names for you!
Check your data in the Table view; ensure that a .1 discount applies a 10% discount, .15 applies a 15% discount, 0 applies no discount, etc. Don't worry about any rounding.

Save the project and, from the course directory, submit the CLI tests.