Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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 , 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.
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |