Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a table of data. One of the columns contains a number + letter combination to identify the item. Like 1A, 1B, 1C, 2A, 2B, 2C, M1A, C1A, etc. I would like to create a grouping of the rows that match a certian name, and then reference this grouping in other calculation. So say "Group 1" is 1A, 1B, 2A, 2B. How would I go about this?
Thanks
Hi,
You can create conditional forum that will transform source IDs into Groups.
Sample conditions:
If ID column equals "1A" then "Group 1"
If ID column equals "1B" then "Group 1"
If ID column equals "2A" then "Group 1"
If ID column equals "2B" then "Group 1"
After that you will be able to GroupBy on New Group column. Hope it helps.
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:
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.
@DataVizzer It makes sense, but I cannot figure out the second to last item. There doesn't seem to be a way to specify Item = 1A
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |