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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Redfox_delta1
Helper I
Helper I

Is there another way of making a relationship between a date table and another table ?

Hi Community,

 

I have a calendar date which has a relations with 3 other tables which have their own dates which works well.

 

I created a calculated columnlink in one of these tables and it contains a list of salesforce id hyperlinks to salesforce records.

 

As soon as I drop the column into my table i get the error below.

 

When I click on fix it forces me to make a relationship between the columnlink and the calendar date table.

 

  

1.jpeg

2.jpeg

 

My Calendar date already has relationship with other tables.

 

Would anyone be able to suggest a way of pulling  my SF client links column into my table which has the calendar dates. Going forward how do I over come these can't see the display visual errors when I already have relationship already established.

1 ACCEPTED SOLUTION

Hi,

The problem is that there is no common column (other than date) between the LD and Camp tables.  As you can see in the image below, as long as you drag all fields from any one of the 2 tables, there is no problem.  The moment i drag a field from the other table (in my case the LD table), the visual renders an error.  I have also corrected a relationship in this file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

12 REPLIES 12
Redfox_delta1
Helper I
Helper I

@bolfri where you able to view the file?

Hi,

The problem is that there is no common column (other than date) between the LD and Camp tables.  As you can see in the image below, as long as you drag all fields from any one of the 2 tables, there is no problem.  The moment i drag a field from the other table (in my case the LD table), the visual renders an error.  I have also corrected a relationship in this file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur  thank you your solution works.

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Redfox_delta1
Helper I
Helper I

pitcraj
Helper I
Helper I

CAMP table doesn't show anything common to connect LD & Main Calendar tables, need either a date column or id column

Redfox_delta1
Helper I
Helper I

Hi @bolfri ,

 

Thank you for your response.

 

Please see the sample file where you will see that Name,Columnlink and ID do not appear in the table.

https://drive.google.com/file/d/1CTmj_cS_J9Koi4luGbCXj7Hh25Fbl8Jf/view?usp=sharing 

 

Thanks for your help.

Hi @Redfox_delta1,

 

I think you're missing something important.

bolfri_0-1671822739662.png

 

bolfri_1-1671822756802.png

 

You're trying to link date field with url field, so that's why it's not working. Also... a connection from Main Calendar suppose to be one direction to the fact table(s). 

 

What is the business connection between those two tables? There is no common column to connect them. I think you've choose wrong file maybe?





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

Proud to be a Super User!




@bolfri the file is correct I just removed a lot of data. What would I need to do to connect the url field to this table. What would I need to look for the ensure that there is a common link bewteen them. Common connections are ID in both tables and created date.

 

 

Then you've removed this created date and ID's that's needed to connect. Plese, give me the sample data with that columns. Without them I can't help you with relationship 🙂





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

Proud to be a Super User!




bolfri
Super User
Super User

Can you provide an pbix file with this issue? Sample rows needed to see understand the problem and give you a solution.





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

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors