Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

Happy New Year Power BI aficionados   So I have a data set imported into Power BI (via a database source) that looks as below:   Col1 Col2 Col3 Col4 Col5 Col1Value Col2Value null nul...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    you can use Power Query with Group By

     

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

I created a calculated table:

Table 2 = 
SUMMARIZE(
    Sheet5,
    Sheet5[Col1],
    "Col2", MIN(Sheet5[Col2]),
    "Col3", MIN(Sheet5[Col3]),
    "Col4", MIN(Sheet5[Col4]),
    "Col5", MIN(Sheet5[Col5])
)

 

Best regards,
Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi Anonymous 


is your problem solved?

If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.