Forum Discussion
Help with Flattening to One Row, Transpose with Text Combined
Hi, I've searched the community for a way to do this. I've tried grouping then working with subtables but I can't get anything to work. Below is the raw data then what I need to have. Grouped by Fund, Fund Desc and Fund Notes
Thanks for any help!
Carol
2 Replies
- AilleryO
Memorable Member
Hi,
Here is a dsicussion that might help you :
https://community.powerbi.com/t5/Desktop/CONCATENATE-AND-CONCATENATEX/td-p/727461
If I understood... your problem is just to concatenate the values in relationship name ?
Have a nice day
It's a little more complicated then that.
I need to group them by FundID then create 3 new columns with kind of Relationship Type (3 different types) and then list the Relationship Names for each of those 3 Relationship Types comma separated. It's like Pivoting the Relationship Type with Relationship Names (Text Values) but some have more than one relationship names which I want comma separated.
