Forum Discussion
joins in table
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
2 Replies
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
table 1 has date column which data type is also date .. and same for other tables .
