Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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
Resolver I
Resolver I

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

@Anonymous 

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
Resolver I
Resolver I

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.