Forum Discussion

Coffeinalytics's avatar
Coffeinalytics
Regular Visitor
2 years ago
Solved

Creating a table of columns from another table

Hi, I just started learning power BI and I have a question that might seem silly but I would appreciate if anyone could help me.

 

So, I have a table that has too many information, and some columns, even tho they are related, would be easier to read if they were in a different table.

 

My idea was to create a "details" table from columns that can be quantified, like "price", "miles", "driver" and I was able to achieve what I wanted using "reference", however, I wonder if there is a way to reach the same results with coding.

Also, if I was to create a relationship between both tables, Should I create an index column in the original table and then use it as a foreign key in the new table?

 

I don't know if my logic is broken, but I hope you guys can understand.

 

Thank you!

 

2 Replies