In many ways, calculated columns can *replace* work that you used to do in Google Sheets.  

For more info on the formulas available in calculated columns, check out the Google docs:

https://support.google.com/datastudio/answer/6299685?hl=en