Forum Discussion

alvenn's avatar
alvenn
New Member
2 years ago
Solved

Retrieving data from a table within a cell

Hi everyone!   I am new to PowerBI and trying to find my way around. I have a problem maybe some of you can solve. I have one main data data source which is a Sharepoint List, let's call it A. This...
Need Help
  • alvenn's avatar
    alvenn
    2 years ago

    Thanks for the answer, but did not work either.

     

    In the end, tinkering a bit I find a solution / workaround. I noticed the "Table" fields have another field with an ID, corresponding to the entry in the table. So I created a new table ("C") and performed a query based on that ID to retrieve the data I was looking for in a column. This also has the advantage of not creating new records in my table "A".

     

    In case this is of interest to anyone, this is the code I created to get the name of the person, stored in Table "B":

     

    Name = LOOKUPVALUE('B'[Name],'B'[Id], 'A'[TEBOberversLookupId])Name = LOOKUPVALUE('B'[Name],'B'[Id], 'A'[TEBOberversLookupId])

     

alvenn's avatar
alvenn
New Member
2 years ago

Thanks for the answer, but did not work either.

 

In the end, tinkering a bit I find a solution / workaround. I noticed the "Table" fields have another field with an ID, corresponding to the entry in the table. So I created a new table ("C") and performed a query based on that ID to retrieve the data I was looking for in a column. This also has the advantage of not creating new records in my table "A".

 

In case this is of interest to anyone, this is the code I created to get the name of the person, stored in Table "B":

 

Name = LOOKUPVALUE('B'[Name],'B'[Id], 'A'[TEBOberversLookupId])Name = LOOKUPVALUE('B'[Name],'B'[Id], 'A'[TEBOberversLookupId])