Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How do I rollup duplicate rows into one row?

I have a report with duplicate rows that I need to rollup into one row. The rows have a Member ID that I would liked rolled up (grouped by?). The top table shows the rows as they are now. I need to r...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I found out the issue. The fields Diabetes, COPD, Asthma, CAD, and HF are not fields collected by Power BI. There are custom columns created by a funtion (IF statements). They don't show up in Power Query. 

     

    I was able to rollup the rows by exporting the table to CSV and loading the CSV file into Excel. I then ran Power Query in Excel to roll up the rows.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Select all columns other than Diabetes, COPD, Asthma, CAD and HF, right click and select "Unpivot Other columns",  Select the Attribute column and go to Transform > Pivot.  See the image below

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I found out the issue. The fields Diabetes, COPD, Asthma, CAD, and HF are not fields collected by Power BI. There are custom columns created by a funtion (IF statements). They don't show up in Power Query. 

 

I was able to rollup the rows by exporting the table to CSV and loading the CSV file into Excel. I then ran Power Query in Excel to roll up the rows.