Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to make a relationship between two columns of different tables having Date/Time format with no success.
See screenshot below:
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
Solved! Go to Solution.
Hi @FraChi ,
These two columns can't find the corresponding value at all.
For example, I have two tables like these.
(Table2)
(Table1)
I got this when I create a relationship between the two tables:
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.
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.
Wait, you are trying to create a relationship between Start Date in Table1 and Ring # in Table 2?
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.
(Table2)
(Table1)
I got this when I create a relationship between the two tables:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |