joins in table

[rebam12]

i have two tables

both table have date column.*table1 and table2

i create a clendar table. and join the both tables date column into calendar table date column .. but i did not get the result

like

when i create drag calendar date and table 1 date column into table then i only get table1 dates. other one looks emty. 

first i joined both tables from ID and then date into calendar table 

[bhanu_gautam]

@rebam12 , First mark date table as DATE TABLE by going to modelling tab and select Mark as Date Table

Ensure that the relationships are set to "Many to One" and "Single" direction from the calendar table currently it is bi-directional 

If you need to use both tables in the same visual, you might need to set one of the relationships to "Inactive" and use DAX functions like USERELATIONSHIP to activate it when necessary.

And Use calender table column in visuals

[rebam12]

table 1 has date column which data type is also date .. and same for other tables .