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.
Hi,
I have data like below in 3 different sheets.
Date | Twitter Page | Like |
1/1/2017 | Asia | 1 |
2/1/2017 | India | 2 |
3/1/2017 | China | 3 |
Date | Facebook Page | Like |
1/1/2017 | Asia | 1 |
2/1/2017 | India | 2 |
3/1/2017 | China | 3 |
Combine sheet
Date | Total Like |
1/1/2017 | 2 |
2/1/2017 | 4 |
3/1/2017 | 6 |
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
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
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?
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |