Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 

  • Hi, good morning.

     

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

     

    Regards!

     

2 Replies

  • Hi, good morning.

     

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

     

    Regards!

     

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion

    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.