cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MeBlank Frequent Visitor
Frequent Visitor

Merge 3 column into 1 row

Hi all,

 

I am new to Power BI and in need of help. I have a set of data which i would like to like to merge them into 1 column with multiple rows.

 

 

Name       Rank        ID             Score

ABC           2            123            95

DEF           5             456            56

 

 

I would like it to be:

Name     Score
ABC         

2               95                                          ROW 1

123

--------------------------------------------------------------------

DEF

5              56                                           ROW 2

456

--------------------------------------------------------------------

 

I need the data to be presented in such in dashboard actually. But I can't make it work. 

I'm not sure if this is doable. Need some advice. 

Thanks guys.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator Eric_Zhang
Moderator

Re: Merge 3 column into 1 row


@MeBlank wrote:

Hi all,

 

I am new to Power BI and in need of help. I have a set of data which i would like to like to merge them into 1 column with multiple rows.

 

 

Name       Rank        ID             Score

ABC           2            123            95

DEF           5             456            56

 

 

I would like it to be:

Name     Score
ABC         

2               95                                          ROW 1

123

--------------------------------------------------------------------

DEF

5              56                                           ROW 2

456

--------------------------------------------------------------------

 

I need the data to be presented in such in dashboard actually. But I can't make it work. 

I'm not sure if this is doable. Need some advice. 

Thanks guys.

 


@MeBlank

In Power BI, the doable equivalent would be creating a calculate column as below.

Name_ = Table1[Name]&CONCATENATE("_",Table1[Rank])&CONCATENATE("_",Table1[ID])

Capture.PNG

 

Capture2.PNG

3 REPLIES 3
CahabaData New Contributor
New Contributor

Re: Merge 3 column into 1 row

well this is just thinking out loud; 

* make a dupe calculated table with just Rank, Score columns (table 2)

* delete Score column from table 1

* transform table 1 to single column 

* join table 2 to transformed table 1 on Rank field

 

 

www.CahabaData.com
Moderator Eric_Zhang
Moderator

Re: Merge 3 column into 1 row


@MeBlank wrote:

Hi all,

 

I am new to Power BI and in need of help. I have a set of data which i would like to like to merge them into 1 column with multiple rows.

 

 

Name       Rank        ID             Score

ABC           2            123            95

DEF           5             456            56

 

 

I would like it to be:

Name     Score
ABC         

2               95                                          ROW 1

123

--------------------------------------------------------------------

DEF

5              56                                           ROW 2

456

--------------------------------------------------------------------

 

I need the data to be presented in such in dashboard actually. But I can't make it work. 

I'm not sure if this is doable. Need some advice. 

Thanks guys.

 


@MeBlank

In Power BI, the doable equivalent would be creating a calculate column as below.

Name_ = Table1[Name]&CONCATENATE("_",Table1[Rank])&CONCATENATE("_",Table1[ID])

Capture.PNG

 

Capture2.PNG

MeBlank Frequent Visitor
Frequent Visitor

Re: Merge 3 column into 1 row

I guess I have to go with this method. Or maybe use individual cards to display the data.

 

Thank you for the help.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 379 members 4,263 guests
Please welcome our newest community members: