Forum Discussion
Cant Create Relationship
I want Date Field to be the relationship between tables
i dont have a primary key or unique field
how can i do that?
Hi gautik92,
According to your description, you want to create a relationship from two table with have the delicate data, right?
If as I said, you can follow below methods:
a. Use a temp table to link above tables’ column which has the dispute date.
SalesRecords:
StockIn:
Customer:
‘SalesRecords’ and ‘stockIn’ contain ‘customer’, use customer to link two table.
b. Search for a field which contain in two tables and has the unique data, use it to create the relationship.
‘SalesRecords’ and ‘stockIn’ contain ‘Date’ and it has unique data, use date to create relationship.
c. Use LookupValue function to get the value currently.
Lookupvalue(SalesRecords[Amount],SalesRecords[CustomerID],Values(StockIn[CustomerID]))
Reference:
Regards,
Xiaoxin Sheng
3 Replies
- ankitpatira
Community Champion
gautik92 You can simply create relationship between date fields from two tables provided field that you're creating relationship FROM doesn't have any duplicates.
Having Duplicate date fields
Hi gautik92,
According to your description, you want to create a relationship from two table with have the delicate data, right?
If as I said, you can follow below methods:
a. Use a temp table to link above tables’ column which has the dispute date.
SalesRecords:
StockIn:
Customer:
‘SalesRecords’ and ‘stockIn’ contain ‘customer’, use customer to link two table.
b. Search for a field which contain in two tables and has the unique data, use it to create the relationship.
‘SalesRecords’ and ‘stockIn’ contain ‘Date’ and it has unique data, use date to create relationship.
c. Use LookupValue function to get the value currently.
Lookupvalue(SalesRecords[Amount],SalesRecords[CustomerID],Values(StockIn[CustomerID]))
Reference:
Regards,
Xiaoxin Sheng
