Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create new table/column showing same type values of two different tables

Hi Team,   i am fairly new to PowerBi and here we go my first question.  I have two tables containing the same type of information. I want to create a new column showing the available data of thes...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    According to my understanding, you want to combine two columns from two different tables, right?

     

    You could use the following formula to calculate a new table:

    New Table =
DISTINCT (
    UNION ( DISTINCT ( Table1[Column1] ), DISTINCT ( Table2[Column2] ) )
)

    My visualization looks like this:

    Is the result what you want? If you have any questions, please upload some data samples and expected output.

    Please do mask sensitive data before uploading.

     

    Best Regards,

    Eyelyn Qin

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

Did I answer your question? Please mark my reply as solution, thank you~

 

Best Regards,

Eyelyn Qin