Forum Discussion
How to combine multiple rows into one row
I have a report where members have multiple health conditions and risk factors associated with them. Here is an example:
Here the member ID 92919600 has two conditions. This is shown as two rows. I want this rolled up or grouped into one row with all the data (both conditions).
I am looking at ROLLUP and GROUPBY as options. There is no data to summarize.
| Member ID | Diabetes | COPD | Asthma | CAD | HF | Depression | Condition Opt Out Diabetes | Condition Opt Out COPD | Condition Opt Out Asthma | Condition Opt Out CAD | Condition Opt Out HF | Member Engagement Level | Member Engagment Level Reason | Member Engagement Level Date |
| 92918600 | Low | N | N | N | N | N | N | Low | 2021/03/11 00:00:00 | |||||
| 92918600 | Low | N | N | N | N | N | N | Low | 2021/03/11 00:00:00 |
Hi Anonymous ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- AnonymousNot applicable
you could try the "GroupBy" Function in powerquery.
GroupBY MemberID: Grouping rows with Power BI / Power Query — Powered Solutions
- v-lionel-msftCommunity Support
Hi Anonymous ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.