Cant Create Relationship

[gautik92]

I want Date Field to be the relationship between tables 

i dont have a primary key or unique field 

how can i do that?

[ankitpatira]

@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.

[gautik92]

Having Duplicate date fields

[Anonymous · Accepted solution]

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:

lookupvalue function

Regards,

Xiaoxin Sheng