Why would you create a Calculated Column in Power Pivot?

So you can create a calculation in that column that is different for each row$/$record$.$

So you can use Excel functions that are familiar to you.

So you can create a calculated field in a PivotTable.

So you can add additional dimensions to your data.