How to retrieve data from another table?

[Anonymous]

I would like to know if it is possible to access data from one table, without having to expand it, for example, I am working on a table called Critical Post, and I need to access data that is in another table called Critical Post Workstation, but I cannot expand -there, and the only thing I have is this column that references the table that contains the data I need, how can I proceed?

[Anonymous]

Hi @Anonymous ，

Could you please provide some sample data in table Critical Post and Critical Post Workstation and the relationship between these 2 tables? Which data you want to retrieve from Critical Post Workstation? Is there any condition when retrieve data?

Best Regards

Rena

[TomMartens · Accepted solution]

Hey @Anonymous ,

I'm wondering why you can't expand the table.

But neververthless, you can access the content of the table

table[columnname]{rowname}

I recommend reading this article: https://ssbi-blog.de/blog/technical-topics-english/tables-in-power-query-how-when-and-why/

Hopefully, this gets you started. 

Regards,
Tom

[Anonymous]

@TomMartens If I expand this Critical Post Workstation table within my Critical Post table, the id of my Critical post table will double and this will generate an error because of the relationship. It is not possible to have two identical id's within the Critical Post, but with the expansion this ends up happening.

[az38]

@Anonymous 

you can use DAX techniques in the report modes.

It is a maximum what I can say with so poor problem statement 🙂