Building Relationships between Tables

[Nick221_]

I have two tables that both contain dates. Specifically, Month & Year. I want to add a slicer to be able to filter by Month and Year and it will update both tables accurately. I have built a Data table. I am trying to link both tables to the data table. However, It will not let me have two realtionships to the same data. How can I connect both tables to the data table?

[amitchandak]

@Nick221_ , Create a date with help from month and year in both tables and join with date table, remove join between table

for text month

date = datevalue("01-"&[month]&"-"&[Year])

if month is number

date =  date([Year], [month], 1)

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...