cancel
Showing results for 
Search instead for 
Did you mean: 
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 IV
Super User IV

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

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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

FraChi
Regular Visitor

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.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors