Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Can you please advise how i can combine rows in the same column if values in the columns (1 & 2) are the same?
Solved! Go to Solution.
Group By Column1 and Column2 with operation all rows and name it something like "All".
You'll get a formula such as:
= Table.Group(#"Changed Type", {"Column1", "Column2"}, {{"All", each _, type table [Column1=nullable text, Column2=nullable text, Column3=nullable number, Column4=nullable number]}})
change the each _ to each Table.FirstN(Table.FillUp(_,Table.ColumnNames(_)),1) to end up with the below
= Table.Group(#"Changed Type", {"Column1", "Column2"}, {{"All", each Table.FirstN(Table.FillUp(_,Table.ColumnNames(_)),1), type table [Column1=nullable text, Column2=nullable text, Column3=nullable number, Column4=nullable number]}})
Just remove all columns except for the table column and expect.
Group By the Columns that are common, Column1 and Column2. You are grouping by Column3 and Column4.
@spinfuzer Thanks, I could do that with the simple sample.
However, when i tried with more columns, I could not get it correct.
Below is a raw data
I did query and grouping; but turned out incorrectly.
Column10 and Column11 are not null.
You can select them and then do a replace values blank with null then perform the group by fill up.
Group By Column1 and Column2 with operation all rows and name it something like "All".
You'll get a formula such as:
= Table.Group(#"Changed Type", {"Column1", "Column2"}, {{"All", each _, type table [Column1=nullable text, Column2=nullable text, Column3=nullable number, Column4=nullable number]}})
change the each _ to each Table.FirstN(Table.FillUp(_,Table.ColumnNames(_)),1) to end up with the below
= Table.Group(#"Changed Type", {"Column1", "Column2"}, {{"All", each Table.FirstN(Table.FillUp(_,Table.ColumnNames(_)),1), type table [Column1=nullable text, Column2=nullable text, Column3=nullable number, Column4=nullable number]}})
Just remove all columns except for the table column and expect.
Check out the July 2025 Power BI update to learn about new features.