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. Doing so entails grouping by the clients.

For users with Excel 2010 or 2013 for PCs, the free Power Query add-in will need to be downloaded; ... From the Text Column group, click Split Column, ... Total_Price and Total_Cost. Let’s create ...

Adding an index column in Power BI To make this work, we must add a new column and populate it with the right values. Specifically, we’ll run a query that will add an index column.