How to merge rows contain same id and remove null values of duplicate rows in Power BI

Question

Here My Table contains five columns that are the same value and the other three columns are mixed null values due to this duplicate columns are generating.Help me to resolve this.

score 1 · Accepted Answer · answered Dec 28 '20 at 06:35

1

After reading the many articles found a solution, we need to use the group by selecting the value which you need distinct and apply conditions where we need to merge columns

After applying the aggregation result will be given below

answered Dec 28 '20 at 06:35

KARTHIKEYAN.A

18,210
6
124
133

Is that meeting your expectation? or you still searching for some solution? – mkRabbani Dec 28 '20 at 11:43
Pls, post if you have any alternative ones and it will be useful to a community members. – KARTHIKEYAN.A Dec 28 '20 at 19:34

How to merge rows contain same id and remove null values of duplicate rows in Power BI

1 Answers1