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...
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 .
