Forum Discussion

M-M-P's avatar
M-M-P
Icon for Helper III rankHelper III
7 years ago
Solved

Copy a column from Table A to Table B

Hi
I thought this would be an easy one.
But after many attempts and lots of forum reading, I can't find a solution. Probably just me who is new to Power BI and DAX.

So how do I copy a column from Table A to Table B?
The column I would like to copy is a calculated column.
So doing it in Power Quray I don't think will work.

 

Thanks in advance

  • If there is a relationship between tables then use RELATED function otherwise LOOKUPVALUE

2 Replies

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

    If there is a relationship between tables then use RELATED function otherwise LOOKUPVALUE

    • M-M-P's avatar
      M-M-P
      Icon for Helper III rankHelper III

      HotChilli 

      Thank you very very much :smileyvery-happy:

       

      I got LOOKUPVAUE to work.

      I had been looking at LOOKUPVAUE but not understood how it worked.