Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
Lets imagine I have bunch of referential tables, and I'd like to have one table consist of
Fcttbl[ID] Ref_Product[Product] Ref_Country[Country] Ref_Category[Category] Ref_Subcategory[Color]
All of these are connected to Fcttbl, but no other connections between them, if that count
Thank you in advance for your help
Solved! Go to Solution.
I think you should just be able to use SUMMARIZECOLUMNS, like
New Table = SUMMARIZECOLUMNS(
Fcttbl[ID],
Ref_Product[Product],
Ref_Country[Country],
Ref_Category[Category],
Ref_Subcategory[Color]
)
I think you should just be able to use SUMMARIZECOLUMNS, like
New Table = SUMMARIZECOLUMNS(
Fcttbl[ID],
Ref_Product[Product],
Ref_Country[Country],
Ref_Category[Category],
Ref_Subcategory[Color]
)