Get data from other related table

[camilo_torron]

Hi! I'm new into PBI and i would appreciate your help. This is the issue:

I have a table A with a column Id's and other columns, and another table B with the Id's in table A and some more, and a column called "label" with the word related to this id. I also have a slicer where i filter the data from table A. The question is: 

How can i get the data from the column "label" related to the id contained in table A? 

I can't modify into the query editor because the data model has to be exctly this, i can only act on "REPORT" page.

Thanks for your time

[iamprajot · Accepted solution]

if both the tables are related to each other in Relationships then use Related otherwise use LOOKUPVALUE

[camilo_torron]

Thank you it really helped.