Create a Calculated Column from using a column from another linked table

[Anonymous]

Hallo guys

So I have a table with a column called readerplace, this column contains a code which indicates whether a specific room was entered or exited. The problem is, the column which shows which code is an enter or exit is in a different table which I already linked with the first table, but I need to use the column which shows enter or exit in a calculated column in the first mentioned table. I already tried merging them in the hopes that it would link the enter and exit to readerplace column in the first table, but just gave me empty columns. 

I know the link works well, because if I put the enter/exit column from second table with the readerplace and date column of the first table in a table visualisation it matches perfectly, but I still cant use it in a calculation.

Any help will be very eppreciated

[v-yuta-msft]

Hi Kaldorr,

Do the two tables have relationship based on the date column? What's your expected result? In addtion, could you please provide more details about the tables? 

Regards,

Jimmy Tao

[Anonymous]

Thank you for the reply. The end result is to calculate the difference between the exit time and last entrance time. For some reason my photos dont want to add now, but as I said the main table has a column called readerplace which contains a code, date and a bunch of other columns. The linked table has a readerplace column and a column with exits and entrances, no date column. The link is between the readerplace columns, because the linked table shows wich of these readerplaces are exits and which were entrances so every readerplace code represents a door which is either a exit or entrance. I have been using RELATED dax fucntion in the meantime and it seems to be working, but I am not sure.