how to create dimension table with 2 different fact tables

[bluetronics]

Hello!

Is there anyone let me know how to create a dimenstion table for relationship with fact tables?

Table A

Date    ITEM    QTY           Date        ITEM             QTY

1/1        A          2               1/2            A                 4

1/2       B           3                1/3            D                 5

1/3       C           4

1/4       A           2

What I would like to make a dimension table below:

ITEM

A

B

C

D

Thanks in advance.

[amitchandak · Accepted solution]

@bluetronics , Try to create a new table as

distinct(union(all(Table1[item]), all(Table2[Item])))

O

distinct(union(distinct(Table1[item]), distinct(Table2[Item])))

refers to https://www.youtube.com/watch?v=Bkf35Roman8 video video

[bluetronics]

Thank you for your feedback. It works what I exatly wnat to get.