Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
---|---|
84 | |
79 | |
63 | |
62 | |
51 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |