Relationship between two tables

[gopichilla]

Hi All,

I have two tables but I can't possible to make the relationship to those tables.

.

Thanks

[v-ljerr-msft]

Hi @gopichilla,

How is Employee related to Category between the two tables? Is there any logic? Could you explain it a little with some sample data?

In addition, have you tried using the LOOKUPVALUE function to create a new calculate column in your employee table in this scenario? The formula should be similar like below. 

column1 =
LOOKUPVALUE (
    'UserTable1'[Category],
    'UserTable1'[User], 'Employee_Table1'[Employee_Number],
    'UserTable1'[Date], 'Employee_Table1'[Date]
)

Regards

[gopichilla]

I used blow query, I didn't get any data.

I want the relationship between two tables please help me on this issue.

Thanks 

[vanessafvg]

what are you trying to get out of the data?  you can join on date, so  create a separate date table and then link both of the tables on date to that table, however what are you trying to get out of joining the data?  What do you need to see?

[gopichilla]

Thanks for quick response. 

I created date table manage relationships to three tables I didn't get any data. 

I want the employee wise category.