Forum Discussion
How to retrieve data from another table?
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
Super UserHey 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
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.