Forum Discussion
Related query
I am trying to use the related query for the following tables.
The customer table is linked to Location and Location is linked to Survey. I want one column from the Survey table in the customer table but when using the related query it shows blank result. Can you help me out with this ?
3 Replies
Anonymous , It can not directly come like that
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8amitchandak I tried by getting the value by all these four methods but still the column that i want is ending up just having blank values
Hi Anonymous ,
Could you please provide some sample data(exclude senstive data) in the table Customers, Locations and Survey with Text format and the base fields which these three tables create relationships on? Please also provide your expected result base on your provided data. It is better if you can provide a simplified pbix file. You can refer the following link to share the file with us. Thank you.
How to upload PBI in Community
In addition, please try the methods in the following links and check if the problem can be resolved...
1. Change the cross filter direction to Both:
2. LOOKUP
LOOKUPVALUE – assigning of values from other table without relation
Using LOOKUPVALUE with inactive relationship
Best Regards
