Forum Discussion
Concatenate unique values from multiple columns
Dears,
I have below table
| Custid | Bulding | Land | shares | cash |
| 1 | 2 | 0 | 2 | 1 |
| 1 | 1 | 0 | 1 | 0 |
| 2 | 1 | 0 | 0 | 0 |
| 3 | 0 | 0 | 0 | 0 |
| 2 | 0 | 1 | 0 | 0 |
| 4 | 2 | 0 | 0 | 0 |
i need to create new column coll type where the expected result have to be.
| Custid | Colltype |
| 1 | Bulding, Shares, Cash |
| 2 | Bulding , Land |
| 3 | |
| 4 | Bulding |
1 Reply
- AllisonKennedy
Community Champion
In Power Query, unpivot the data first:
You can rename your columns here, but I'll keep as 'attribute' and 'value' to make this post more generic.
Then close and apply. Create a new MEASURE:
Coll Type = CONCATENATEX(VALUES(awadh[Attribute]), awadh[Attribute], ", " )Then add that to a table visual with your Custid:
