Forum Discussion
How I can create relationship between excel sheet with no same or related column with fact table?
Hi all,
I have an excel sheet which have loaded that in data modeling, so new table is exist, but for creating relationship between this new table and fact table, thare is not any same column, for example no keys or other columns for connecting them together. I do not have even date column. The excel sheet only has two columns. They are MD and TVD.
Excel sheet is included two column MD & TVD. I need to find Right TVD value when I enter the MD value. Please, refer to my photo. For instance, I have MD=10, so the result should return TVD= 20.
Questions: 1. Should I create relationship between this excelsheet and fact table? If yes , How?
MD value comes from fact table and then I should find the related TVD value in Excelsheet. That means I should go to Excel sheet and find the right TVD value.
Hi, Aysen
According to your description, you want to get the [TVD] in the excel sheet when you enter an the value of the [MD] . And you want to get this value in your visual created by the fact table but two tables has no related columns to create relationship?
For your needs, if you want to input the corresponding value in the Excelsheet, and then get the corresponding [TVD], then we can directly get the corresponding value without creating a relationship.
2 Replies
Hi Aysen
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi, Aysen
According to your description, you want to get the [TVD] in the excel sheet when you enter an the value of the [MD] . And you want to get this value in your visual created by the fact table but two tables has no related columns to create relationship?
For your needs, if you want to input the corresponding value in the Excelsheet, and then get the corresponding [TVD], then we can directly get the corresponding value without creating a relationship.
