Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hsfo
New Member

Connecting two tables where the rows in one correspond to column headers in the other

Hi, 
Im trying to connect two tables where the row values in one are listed as column headers in the others. The caveat is that I need the column headers to stay in that shape (i.e transposing directly won't work). 

 

Example: Lets say we are predicting house prices. We have a table with features and their importance (table 1). We also have a table with some houses and the values for those features. We need to be able to connect the information about the feature importance when analyzing the observations of the specific houses. 

 

Table 1

FeatureImportance 
Floor size0,9
Number of bathrooms0,8
Number of bedrooms0,7

 

Table 2

House IDFloor sizeNumber of bathroomsNumber  of Bedrooms
house_1389434
house_2125012

 

How can I connect the features that are shown as rows in table 1 with the features shown as columns in table 2? 

I need the data in the table 2 columns. 

 

I need to be able to rank the columns based on importance. Any ideas on how to do this? 

 

1 REPLY 1
jbwtp
Memorable Member
Memorable Member

Hi @hsfo,

 

There are few options to do what you want. The simpliest can be pivoting Table1 and then appending to Table 2, in this case you will have the weights "data in the table 2 columns" as you wanted.

 

I wonder, however, what are you going to do with this data? "rank the columns based on importance" sounds a bit strange. If you order columns according to thier weightings it is not going to provide any benefit in the report as the Designer really does not care about the columns order in the data, this is only a sequence of field in a visual [e.g. a table] that sets the order of appearance.

 

What is you ideal output?

 

Thanks,

John  

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors