Forum Discussion
Anonymous
5 years agoNot applicable
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 ...
- 5 years ago
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.
Anonymous
5 years agoNot applicable
you could try the "GroupBy" Function in powerquery.
GroupBY MemberID: Grouping rows with Power BI / Power Query — Powered Solutions