cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

How to Create relationship?

Hi,

 

I have data like below in 3 different sheets.

 

Twitter 

Date Twitter PageLike 
1/1/2017Asia1
2/1/2017India2
3/1/2017China3

 

Facebook

Date Facebook PageLike 
1/1/2017Asia1
2/1/2017India2
3/1/2017China3

 

Combine sheet

Date Total Like 
1/1/20172
2/1/20174
3/1/20176

 

I want to create a relationship between Twitter -> to -> Combine sheet and same with Facebook -> to -> Combine sheet 

 

Can I create somehow? Is there any way to do this.

 

Kindly Help on this.

 

Regards,

Aditya 

2 REPLIES 2
Community Support Team
Community Support Team

Re: How to Create relationship?

HI @adityavighne ,

In your scenario, you can create relationship between the Date column in Twitter table and Date column in Combine sheet, between Date column in Facebook table and Date column in Combine sheet, use the many-to-one relationship.

Best Regards,

Teige

Re: How to Create relationship?

This will not help.

I have already had a relation  between dates.

 

so when I select Date it gives me total likes not to drill down 

 

Can someone help with this?

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 295 members 2,802 guests
Please welcome our newest community members: