Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
rebam12
Helper I
Helper I

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. 

rebam12_0-1726556402339.png

 

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

rebam12_1-1726556471606.png

 

2 REPLIES 2
bhanu_gautam
Super User
Super User

@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




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






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

rebam12_0-1726558329209.png

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.