Apply Excel's Insert command to add more table columns. Getty. Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns.

Add a calculated column to the Product table in Power BI. Now, let’s display the new field in a visualization: In the Visualizations pane, click the Table visualization.