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

[Anonymous]

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 these two columns.

Example

Table1 Column1

100
101

102

109

Table2 Column2

100

103

110

New Column:

100

101

102

103

109

110

I quite sure it must be an easy one.....just can't see the foresat because of too many trees.

Thanks in advance!

Pascal

[Anonymous]

Hi @Anonymous ,

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

Best Regards,

Eyelyn Qin

[Anonymous · Accepted solution]

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

[amitchandak]

@Anonymous , You can create a new table like

new table = distinct(union(all(Table1[column1]),all(Table2[column2])))

Also find the link of the file, where similar stuff was done

https://www.dropbox.com/s/op9lb78w9utdonz/Distinct%20from%20two%20Tables.pbix?dl=0

[Greg_Deckler]

@Anonymous - I'm not sure about a new column, a new table, definitely:

New Table = 
DISTINCT(
  UNION(
    SELECTCOLUMNS('Table1',"New Column",[Column1]),
    SELECTCOLUMNS('Table2',"New Column",[Column2]),
  )
)