Reference whole column data from another query to this query

[Anonymous]

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 

[AlB]

@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

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 · Accepted solution]

Hi, good morning.

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

Regards!