Learn how to add a calculated column in Microsoft Power BI to enrich your data and provide easier insights with this guide.

Figure A Transfer the Excel Table into Power Query. How to add a new column in Power Query Our goal is to combine the t-shirt sales by client into a single cell for each client.

The table's properties display, including the columns. You click a column and change the heading to edit the current columns. To add a new column, click "New" and type a heading for the column.