get data from the many to the one side relationship

[0xygen27]

Hello community, 

I got a document where I imported data and made a date table. I got a problem with my date table. The table can't interact with other tables. I tried to make a graph, but it won't be specified :(. 

I made a screenshot about the relationship and about the tables I want to combine. 

[v-huizhn-msft]

Hi @0xygen27,

From your screenshot, there is a relationship between Periodes and 'Dataset Vacatures', which field is use to create the relationship? And what's the mean of Perioden? I am still confusing about your question, please share more details for further analysis.

Best Regards,
Angelia 

[0xygen27]

I used the perioden and date as a relationship, Perioden in the middle is just to show that I want to connect perioden with my date table.

[v-huizhn-msft]

Hi @0xygen27,

The field is used to create a relationship between two tables. So you need to create same value with perioden field, please analyze the compont of it, so you can create the relation successfuly. But, the componts in perioden are nout regular, year/**/weeknum?

Best Regards,
Angelia