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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
FraChi
Regular Visitor

Relationship Date/Time Column

Hello,

 

I am trying to make a relationship between two columns of different tables having Date/Time format with no success.

See screenshot below:

Table.png

 

I tried cardinality Many to Many but the data are not plotted.

I want to use the StartDate in Table2 and the Ring in Table1 because Table2 contains the distinct value of StartDate.

 

Any idea how to make this work?

 

Thanks

1 ACCEPTED SOLUTION

Hi @FraChi ,

 

These two columns can't find the corresponding value at all.

For example, I have two tables like these.

lll6.PNG

(Table2)

lll5.PNG

(Table1)

I got this when I create a relationship between the two tables:

lll7.PNG

So you should create relationship between [Ring] column with [Ring[#]] column.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-lionel-msft
Community Support
Community Support

Hi @FraChi ,

 

"I want to use the StartDate in Table2 and the Ring in Table1 because Table2 contains the distinct value of StartDate."

It doesn’t make sense to use these two columns to create a relationship.

Maybe you can use [Ring] column in table1 and [Ring[#]] in table 2 to create a relationship or use [StartDate] in table1 and [Start Date[yyyy-mm-dd hh:mm:ss]] in table2 to create a relationship.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Greg_Deckler
Super User
Super User

Wait, you are trying to create a relationship between Start Date in Table1 and Ring # in Table 2?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

I am trying to make a relationship between StartDate of Table1 and Start Date [yyyy-mm-dd hh:mm:ss] of Table 2.

Any idea why the relationship between StartDate of Table1 and Start Date [yyyy-mm-dd hh:mm:ss] of Table 2does not work?

Hi @FraChi ,

 

These two columns can't find the corresponding value at all.

For example, I have two tables like these.

lll6.PNG

(Table2)

lll5.PNG

(Table1)

I got this when I create a relationship between the two tables:

lll7.PNG

So you should create relationship between [Ring] column with [Ring[#]] column.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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