How to combine multiple rows into one row

[Anonymous]

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

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Please refer to my .pbix file.

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.

[Anonymous]

you could try the "GroupBy" Function in powerquery.

GroupBY MemberID: Grouping rows with Power BI / Power Query — Powered Solutions