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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Manage Relationships

Hello Folks... I come across a query where I have to build a relation between multiple tables ,the scenario is like , Parent Node : Category Name (Appliances) Child Node : Sub-Category Name (Washing Machines ,Fans,Lights,..etc,) Leaf Node : (Whirpool , LG, Haier ,ETC ) Table-1 Contains Parent Node values (Category as Col-Header Under that category values ) Table-2 Contains Child Node value-1 (as Column name) Table-3 Contains Child Node value-2 (as Column name) Table-4 Contains Child Node value-3 (as Column name) So now I have to relate these tables with a relation of row value of Table-1 relates to column names of Table(2,3,4) Kindly suggest is this approach is optimal and accurate or not ,If so suggest Dax functions or relevant code . Thanks In advance . @amitchandhak @Arul
1 REPLY 1
Idrissshatila
Super User
Super User

Hello @Anonymous ,

 

use the star-schema model to build the relationship for better performance.

check it here https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

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