Forum Discussion
How to retrieve data from another table?
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?
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
4 Replies
Anonymous
you can use DAX techniques in the report modes.
It is a maximum what I can say with so poor problem statement 🙂
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,
TomTomMartens 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.
