How to create a Dimension table to connect 2 Fact tables

[PBI_newuser]

Hi,

I have 2 fact tables and I want to create a Dimension table to connect these 2 fact tables.

How to create the Dimension table?

Table A (Fact Table):

Model Number	Sales
ABC-123	432
CDE-123	56
ABC-123	255
DEF-123	9884

Table B (Fact Table):

Model Number	Repair
ABC-123	45
GGG-123	36
FFF-123	106
DEF-123	834

Output (Dimension Table):

Model Number

ABC-123

CDE-123

GGG-123

FFF-123

DEF-123

[amitchandak · Accepted solution]

@PBI_newuser , Create a new table like

Model Number= distinct(union(all(TableA[Model Number]),all(TableB[Model Number])))

if you have a unique value in one of the tables use distinct in place of all

example

Model Number= distinct(union(all(TableA[Model Number]),distinct(TableB[Model Number])))

or

Model Number= distinct(union(distinct(TableA[Model Number]),distinct(TableB[Model Number])))

[v-diye-msft]

Hi @PBI_newuser 

If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!

If not, please kindly elaborate more.