Cannot create relationship between two columns.

[tylerbauer]

Hello, I am creating 3 tables that are not measured all on the same date range (some values are measured by week and other are measured by day). I need all 3 tables to change by a slicer. I am wondering if you reccomend using a "datekey" as the way to connect these tables or if I should create a seperate primary key and relationship like in SQL?

[v-caliao-msft]

@tylerbauer,

Do you have datekey in your tables? You can create a Date table in your Power BI data model, and then create relationship between your tables and new date table, then you can add this new date column in date table into a slicer. Please refer to the links below to see the details about how to create date table.
https://kohera.be/blog/business-intelligence/how-to-create-a-date-table-in-power-bi-in-2-simple-step...
https://www.agilebi.com.au/blog/power-bi-date-dimension

If this is not what you want, please elaborate your table strucutre, if possible provide us some sample data, so that we can make further analysis.

Regards,

Charlie Liao

[tylerbauer]

What if multiple columns in a table have the same date? Does this make it unfeasible to connect different tables on date because date won't be unique?