Columns that refer to other tables

[Anonymous]

Hello

I'll try to explain my question in a very visual way.

So my question is, how do I access the data in my Critical Post Workstation table, inside my Critical mailing table, without having to expand it?

[dax]

Hi @Anonymous , 

It seems that you want to get data from another table and show this in current table, right? If so, I think when you merge or append table, you will get a new column which type is table, you need to expand it to get value. Or you might could create relationship between tables, then show this in the same visual to see whether it work or not. So if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello,

I'll try to explain my question in a very visual way.

So my question is, how to access the data from my Critical Post Workstation table, inside my Critical post table, without having to expand it?

[Greg_Deckler]

https://community.powerbi.com/t5/Desktop/Columns-that-refer-to-other-tables/m-p/1064043

[Greg_Deckler]

I think I would need to see the other columns in your two tables. It is very confusing Critical Post and Critical Post Workstation, maybe just refer to them as A and B. Sample data as text would help to recreate. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Maybe a bridge table? So, ditch the current relationship, expand the table, one of the critical post ones, and then create a bridge table using DISTINCT.