cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Columns that refer to other tables

Hello

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

01.PNG02.PNG03.PNG

 

 

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?

4 REPLIES 4
Highlighted
Helper II
Helper II

Columns that reference other tables

Hello,

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

01.PNG

02.PNG

03.PNG

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?

Highlighted
Super User IX
Super User IX

Re: Columns that refer to other tables

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. 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User IX
Super User IX

Re: Columns that reference other tables

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

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Community Support
Community Support

Re: Columns that refer to other tables

Hi @henriqu3nzo , 

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors