Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bluetronics
Helper III
Helper III

how to create dimension table with 2 different fact tables

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.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.