Happy New Year Power BI aficionados So I have a data set imported into Power BI (via a database source) that looks as below: Col1Col2Col3Col4Col5Col1ValueCol2ValuenullnullnullCol1ValuenullCol3ValuenullnullCol1ValuenullnullCol4ValuenullCol1ValuenullnullnullCol5Value (Each 'Col1Value' value within the column Col1 is same in all the rows) What I'm trying to achieve is to have a table on my Power BI report that displays this information as below (i.e. basically I want to merge all the rows and eliminate all the nulls on Col2 to Col5 so there's a single record for Col1Value. Hope that makes sense?) Columns Col2, Col3, Col4 and Col5 are of type text Col1Col2Col3Col4Col5Col1ValueCol2ValueCol3ValueCol4ValueCol5Value Is this possible to do this via Power Query transformations/DAX? Let me know if this is unclear Thanks in advance for your help

Hi Anonymous , you can use Power Query with Group By Regards,MarcusDortmund - GermanyIf I answered your question, please mark my post as solution, this will also help others.Please give Kudos for support.

Help needed to merge rows via Power Query/Power BI DAX

Open Side Menu

Skip to content

Microsoft Fabric Community
Power BI forums
Desktop

Forum Discussion

Related content

Power Query - Merge

Merging Queries in Excel Power Query

Very odd merge behavior in power Query

Merging steps in Power Query

Power Query - Merge Rows