Group data by certain values in a column

Hi MichaelRensing,

to group rows by column values in Power BI Desktop, you can use the Group By feature in Power Query Editor. Here are the steps to do it:

• Select your table of data and click Edit Queries on the Home tab.
• In the Power Query Editor, select the column that contains the number + letter combination (e.g. Item).
• Click Group By on the Transform tab.
• In the Group By window, enter a name for your new column (e.g. Group) and select an aggregate function (e.g. Count Rows).
• Click Advanced and add a condition for each group you want to create (e.g. Group 1 = Item = 1A or Item = 1B or Item = 2A or Item = 2B).
• Click OK to apply the grouping.

You should see a new column with your groups and their counts. You can use this column to reference your groups in other calculations. 

Does this help? If so please mark this answer as accepted solution.