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

Reference whole column data from another query to this query

Dear all,

1, I have two queries in Power BI Query... one is with data, another blank data just with titles...

2, I want to reference/copy the whole column data from another query to this query...

 

Can PBI support this function?? M or DAX ??

 

Tks so much if anyone could answer 

1 ACCEPTED SOLUTION
HenriqueReis
Super User
Super User

Hi, good morning.

 

Maybe you should explore this tool in Power query, so you can combine your two tables, the way you want: 

HenriqueReis_0-1654421809851.png

 

Regards!

 

View solution in original post

2 REPLIES 2
AlB
Super User
Super User

@fior12 

Probably PQ is best for this

Can you show a sample of your two input tables and the expected output?

Show them in text-tabular format (rather than a screencap) so that contents can be copied


SU18_powerbi_badge

Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

 

HenriqueReis
Super User
Super User

Hi, good morning.

 

Maybe you should explore this tool in Power query, so you can combine your two tables, the way you want: 

HenriqueReis_0-1654421809851.png

 

Regards!

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors